What does Conditional format change when highlighting?
 

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?

What does Conditional format change when highlighting?
 

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?

What does Conditional format change when highlighting?
 

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?

What does Conditional format change when highlighting?
 

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?

What does Conditional format change when highlighting?
 

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?

What does Conditional format change when highlighting?
 

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)

"J@Y" wrote in message
...
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?