Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting and VBA
Hi,
I have a sheet with conditional formatting. If the cell contains a zero then it turns yellow and it works fine. I created a macro to add all white cells containing a number greater then zero. To do that I check the Interior.ColorIndex. The funny part is If the cell is yellow because of the conditional formatting(meaning that the value is zero) the VBA code with the Interior.ColorIndex sees it has a code 2(white cell instead of yellow)! Is this normal and how can I fix it? Thank's ahead. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |