This is my first post in this forum
Well I have an excel range where conditional formatting of colorscale is applied. Highest value becomes red, lowest becomes green and shades in between.
Now I need to retrieve the color of these cells at a later point. But the color returned is always white.
Any thoughts how it can be achieved?