Sensing actual format background color

R

Ron

I have a cell with a conditional format that changes the background color as a function of a dynamic variable (> and < tests)

I'm trying to write a macro that branches based on the "actual" color of the cell - which is determined by whether the conditional format has been "keyed" or not

I've learned that
Selection.Intererior.ColorIndex an
Selection.FormatConditions(1/2/3).Interior.ColorInde
return the baseline and conditionally assigned color values but they don't tell me which color index value is in effect for the selected cell at the time

Is there a command that can return the color index that is in effect (either baseline or condition1/2/3)

Thank
 
N

Nathan

Do you mean something like this:

Debug.Print [A1].Interior.ColorIndex
-----Original Message-----
I have a cell with a conditional format that changes the
Click to expand...
background color as a function of a dynamic variable (>
and < tests).
I'm trying to write a macro that branches based on
Click to expand...
the "actual" color of the cell - which is determined by
whether the conditional format has been "keyed" or not.
I've learned that
Selection.Intererior.ColorIndex and
Selection.FormatConditions(1/2/3).Interior.ColorIndex
return the baseline and conditionally assigned color
Click to expand...
values but they don't tell me which color index value is
in effect for the selected cell at the time.
Is there a command that can return the color index that
Click to expand...
is in effect (either baseline or condition1/2/3)?
 
E

e

Thanks Guys. There are some really intelligent folks on this board! Wish I
were one of them.

Ron
 
Top