Maybe you want:
=(a1+180)<today()



RRS wrote:

3/5/2010, The whole column is formated to this type of date.
--
Thanks,
RRS

"Dave Peterson" wrote:

What's in A1?

Make sure it's a real date.

RRS wrote:

I have a need for this same type of formula, except, I need it to highlight
cells that are over 6 months old. I tryed changing the formula to
=(A1-180)<TODAY() and it highlights all cells that have a date in them. Even
if the date was yesterday. What am I doing wrong?
--
Thanks,
RRS

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

--

Dave Peterson
.


--

Dave Peterson