| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting to change ColorIndex?
I used conditional format to highlight numbers less than 1. That part works.
The cells containing numbers less than 1 appears to be highlighted, but when I test its ColorIndex, it still shows -4142, which means its blank. I even went into FormatCell and the Cell shading section was on None. So what exactly does Conditional Formatting do to the cell property that changes the color? Can I get it to change the ColorIndex? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change conditional formatting to coloured alternate rows dependent on a change in date? | Excel Programming | |||
| VBA ColorIndex Formatting | Excel Discussion (Misc queries) | |||
| interior.colorindex used with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting and interior.colorindex | Excel Programming | |||
| Colorindex in a Conditional Format | Excel Programming | |||
Threaded Mode
