View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 20
Default 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