ColorIndex Mystery

[blatkins]

If I use the Fill Color icon on the toolbar and set a cell color to red,
then the color index equals 3. However, if I use Conditional Formatting
and set the color of a cell to red, then the color index equals 2. Why
the difference?

Brian

 

[Guest]

Conditional formatting colors can not be examined with the colorindex
property.

the color index property always displays the interior color of the cell
without conditional formatting applied.

See Chip Pearson's page:
http://www.cpearson.com/excel/CFColors.htm

 

[Ivan Raiminius]

Hi Brian,

colorindex property doesn't show actual cell color when conditional
formatting is in effect. It shows the cell color as if no conditional
format would exist.

Regards,

Ivan