Conditional Formatting with less than, great than, etc

[SirHart]

Here's an easy one for you guys, I just can't get it to work though.

I want to format a cell to change colors dependent on if it falls within a certain range from todays date.

If it's 60 days or less from todays date I want it to turn the cell red

If it's between 61 and 89 days I want the cell to turn orange

If it's between 90 and 105 days I want the cell to turn yellow

The current formulas I'm using are

RED Condition 1: =($F$1-TODAY())<60
ORANGE Condition 2: =($F$1-TODAY())<89
YELLOW Condition 3: =($F$1-TODAY())<105

I can't get yellow to show up...I think I might need to use greater than or between symbols? or does the order of the conditions matter? Help!

 

[Jonmo1]

It works for me...

What do you have in F1 at the time you think it should be yellow?
And what color is it actually at that time?

Excel Workbook
	F	G
1	7/24/2011	31
2	8/28/2011	66
3	9/22/2011	91
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F1	1. / Formula is =($F1-TODAY())<60	Abc
F1	2. / Formula is =($F1-TODAY())<89	Abc
F1	3. / Formula is =($F1-TODAY())<105	Abc
F2	1. / Formula is =($F2-TODAY())<60	Abc
F2	2. / Formula is =($F2-TODAY())<89	Abc
F2	3. / Formula is =($F2-TODAY())<105	Abc
F3	1. / Formula is =($F3-TODAY())<60	Abc
F3	2. / Formula is =($F3-TODAY())<89	Abc
F3	3. / Formula is =($F3-TODAY())<105	Abc

 

[chatzmc81]

hello , i am new to this forum and from what i have read so far it is amazing , i am punching above my weight with a new project i have taken on and i need to develope a matrix for my use to tell me when certificates are expiring

i am trying to get a cell to highlight amber if 11 months have passed from =(TODAY) and once 12 months passed highlight red.

does anybody have any advice