Sensing actual format background color
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
|