Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format and VBA
I have certain cells set to colorindex = 6 using Conditional Formatting.
I am trying via vba to act on these cells when encountered. When I try to return the color value such as xColor = Range("A1").Interior.ColorIndex I get an incorrect result. How do I do this and is there a way to set conditional formats vis VBA. Thanks, Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |