Great, that solves things. What exactly does the 1 represent int he () after
FormatConditions?

"JLGWhiz" wrote:

To check the color index of a conditional format, you have to modify the code
a mite.

Sub whatclr()
MsgBox "ColorIndex number is " & Worksheets(1).Cells(4, 3) _
.FormatConditions(1).Interior.ColorIndex
End Sub

Notice the index number after FormatConditions. It can be one of three
depending on which order it was in the original CF setup.

"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?