Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Using "OR"
I'm wanting to use multiple conditions using "OR" for conditional formatting.
Here's the criteria for percentage of completion of 6 and 9 months from entering training: 6 months from entering training 0-25% Red 26-50% Yellow 51-100% Green 9 months from entering training 0-50% Red 51-75% Yellow 76-100% Green Here's an example of a formula that didn't work: =OR(B3+182.5<=TODAY()-182.5,AI3<=25%) B3 is the date entered training and AI3 is the percentage of completion and where I'm wanting to have the background change to match the color criteria. This 1st formula didn't work, so I couldn't continue. Thanks, Robbie -- Michael Robinson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting cells with formulas = "#VALUE!" | Excel Discussion (Misc queries) | |||
conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
Conditional Formatting Bottom 10 with "ties" | Excel Worksheet Functions | |||
Conditional Formatting Bottom 10 with "ties" | Excel Discussion (Misc queries) | |||
Conditional Formatting-can a "then" be placed with the "if". | Excel Worksheet Functions |