How to get a color of a cell with conditional formating ?

[enders]

Hello,

I know that you can read the color of a cell using

ActiveCell.Interior.Color

But if you have a conditional format on that cell and
the condition is true that value still doesn't change.

There are several different conditions in the spreadsheet.
and I am only intrested in the result of the conditions.

Thanks in advance

(VBA code is very welcome)

 

[DominicB]

Good morning enders

Welcome to the board.

Chip Pearson has some interesting routines for extracting the colour of conditionally formatted cells. Yes, it does involve VBA.

http://www.cpearson.com/excel/CFColors.htm

HTH

DominicB

 

[enders]

Thanks

I am sure it will work