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

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