What does Conditional format change when highlighting?

[Guest]

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?

 

[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)

 

[Guest]

How would you test the result?

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)

 

[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)

 

[Guest]

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

 

[Bob Phillips]

That's very different, and very difficult. See
http://www.xldynamic.com/source/xld.CFConditions.html

--
HTH

Bob

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