ColorIndex Mystery

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

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

--
Regards,
Tom Ogilvy


"blatkins" wrote:

>
> 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
>
>
> --
> blatkins
> ------------------------------------------------------------------------
> blatkins's Profile: http://www.excelforum.com/member.php...o&userid=33639
> View this thread: http://www.excelforum.com/showthread...hreadid=534123
>
>

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