What does Conditional format change when highlighting?

J

J@Y

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

Bob Phillips

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

J@Y

How would you test the result?

Bob Phillips said:
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)
Click to expand...
 
B

Bob Phillips

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

J@Y

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