Hi,

Just in case you don't have the formulas, try something like this
#1 =$A1<TODAY()
#2 =$A1=TODAY()+60
#3 =$A1=30

You can go back into the Conditional formatting dialog box by either doing
New Rule or Manage Rules.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"ReapeR" wrote:

I've been through all the questions in here and I'm still having difficulty
grasping this.

I want to conditional format dates that are 60 days, 30 days out and then
when they are overdue. I keep seeing everyone saying to change the formula
to "formula is", but I can't find that anywhere. All I can get to is the
drop down box (Excel 2007) from the CF tab. I go to new rule and get 5
options. (Format all cells..., Format only cells..., Format only top or
bottom..., etc. I've been through them and still no "formula is" option.
Any help would be greatly appreciated.

Just to clarify, I'm trying to color fill green when 60 days or more out,
yellow when 30 days or less out and then of course red, when actually overdue.

Thanks in advance for any help.

James