I need to test the cell to see whether it is colored by conditional
formatting in VB.

"Bob Phillips" wrote:

You would see it if it succeeded because the colour changes.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"J@Y" wrote in message
...
How would you test the result?

"Bob Phillips" wrote:

Because that is the condition being tested, not the result.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"J@Y" wrote in message
...
When I use conditional format to highlight cells, I found that the
FormatConditions(1).Interior.ColorIndex were changed to the same number
no
matter if the cell is highlighted for not. So a cell with a yellow
highlight
and a cell that looks white both have
FormatConditions(1).Interior.ColorIndex
= 6. Why is that?