Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba overlapping conditional formatting
Firstly, I'd like to stress that I'm a VBA rookie, so I'd appreciate replies
will with details and explanations. I'm trying to figure out how to build some VBA conditional formatting to: 1. test multiple cell criteria 2. overlap (when needed) the resulting conditional formatting For example, in my worksheet, I want to test the content of columns N and O for 3 different possible conditions and format the entire row accordingly: if N is blank and O is a number, use a green font for the entire row if N is "RET" and O is "RET", use a grey font for the entire row if N is a number and O is "RET", use a red font for the entire row Plus, I want to test the contents of columns V and W for a single condition and format the entire row accordingly: if V is "Internal" and W is "Internal", use a peach background for the entire row This latter test should be able to overlap with any of the first set. And, lastly, I want to test the contents of column T for a single condition and format the entire row accordingly: if T <1 and the row above =1, then draw a heavy blue line above the entire row And this third also should be able to overlap with any of the prior sets. Finally, when any of these conditions change (so the criteria are no longer met), I need the formatting to revert back to the default. I know this will need to be triggered by a Worksheet_Change event, but have been fiddling for a couple of days without much luck. -- Susan Technical Writer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables and conditional formatting and overlapping | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Overlapping conditional formats | Excel Programming |