Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
color a range of cells based on a criteria
Hi,
I don't believe the conditional formatting tool gives me a solution to this problem, so I probably need VBA. Range B2:M2 contains the months January through December. January is in B2 and December is in M2. In the range B1:M1, "business as usual starts" will either appear or not. If it appears, its location will vary across that range. I'm looking for VBA that will do the following: 1) If "business as usual" is in C1, the range B3:B14 will be highlighted yellow, and the range C3:M14 will be highlighted green (remember, "business as usual" will not necessarily be in C1, but can vary across the range specified above) 2) If "business as usual" does not appear in the range B1:M1, then the range B3:M14 will be highlighted yellow. Clear? I hope so. Thanks in advance. Dave -- Brevity is the soul of wit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
evaluate two cells and calculate based on criteria | Excel Worksheet Functions | |||
sum number of cells based on letter/title criteria | Excel Worksheet Functions | |||
MIN within range based on criteria | Excel Discussion (Misc queries) | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) |