LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting cells with formulas = "#VALUE!" Marcus Analyst Excel Discussion (Misc queries) 1 January 4th 08 06:09 PM
conditional formatting "if part of cell contents contains string" tom ossieur Excel Worksheet Functions 1 March 13th 07 11:11 AM
Conditional Formatting Bottom 10 with "ties" Dan Excel Worksheet Functions 5 May 27th 06 07:16 PM
Conditional Formatting Bottom 10 with "ties" dan Excel Discussion (Misc queries) 1 May 26th 06 10:20 PM
Conditional Formatting-can a "then" be placed with the "if". jhcoburn Excel Worksheet Functions 1 November 15th 05 08:14 PM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"