Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognizing conditional formatting with VBA
Hello group.
Came across a situation today which I couldn't resolve to my satisfaction. Maybe someone here can help... A colleague needed me to code a spreadsheet with a fairly simple requirement. If a certain cell was green, the entire row would be colored green; if the cell was red, the entire row would be shaded red. The issue is the cell I'm basing everything off of is conditionally formatted. Trying to recognize the cell's color via cell.interior.colorindex does not work. I was unable to get any code to recognize the conditionally formatted cell. I finally resolved my problem by eliminating the conditional formatting and hardcoding the conditionally formatted formulas into the VBA module. So, does anyone know of a method to get VBA to recognize a conditionally formatted cell? Art |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Recognizing Cell Formatting To Use In A Formula Or Conditional For | Excel Worksheet Functions | |||
Conditional Formatting Recognizing Greatest Value | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |