Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro alternate conditional format change
Excel 2003 SP3
have spreadsheet with percentages in cells; some cells have "N/A"; already using conditional formatting (3 conditions) to change cell background color for percentages; want background color of cells with "N/A" to remain clear (white); need a macro that will find cells with "N/A" and change them to an alternate background color format (overriding the existing conditional formatting for that cell); if cell changes in future to a percentage, need the 3 conditions format |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for alternate conditional formatting? | Excel Discussion (Misc queries) | |||
conditional format change | Excel Discussion (Misc queries) | |||
Alternate Conditional Pattern as #'s Chg | Excel Discussion (Misc queries) | |||
Change cell colour on formula result change, no conditional format | Excel Programming | |||
Change conditional formatting to coloured alternate rows dependent on a change in date? | Excel Programming |