View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robbie robbie is offline
external usenet poster
 
Posts: 26
Default 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