Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
how to count cells with specific format (background color)? | Excel Discussion (Misc queries) | |||
Format Background Color Teaser | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |