I am trying to write a macro. My objective is to read the color index of a cell and then based on the color index perform some mathematical operations. The color of the cell is based on conditional formatting.
However when I try to put this statement -> Selection.Interior.ColorIndex , it returns the default color of the cell (and not the color based on the condition).
Kindly suggest some way out.