If the condition is true CF applies the value of the ColorIndex property
of the cell's FormatCondition Object.

CF doesn't (and can't) change the ColorIndex property of the cell's
Interior object.

If you want to know whether CF is applied, test the same condition(s)
set in CF.

In article ,
J@Y wrote:

I used conditional format to highlight numbers less than 1. That part works.
The cells containing numbers less than 1 appears to be highlighted, but when
I test its ColorIndex, it still shows -4142, which means its blank. I even
went into FormatCell and the Cell shading section was on None. So what
exactly does Conditional Formatting do to the cell property that changes the
color? Can I get it to change the ColorIndex?