Date formula

  • Thread starter Thread starter J
  • Start date Start date
J

J

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
 
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
 
Thank you for your response but now I'm faced with another delima. Here is
whatI have:
I have a date in a cell, I need for that date to turn red if it is blank or
if the date is prior to 01-Sep-2008. Awaiting your response.
 
It did the blank cell but not the cells with dates priouv to 01-Sep-2008.
Does it matter what format I have the dates appear or typed in. It is typed
in as "9/1/08" however it appears as 01-Sep-2008.
 
You were right. After @ long days of trying to find this formula you have
saved my life/job. THANK YOU So much. How do I post a rate on this? I tried
and can't get it.
 
Glad I could help.

I don't think there is any rating - you can just mark whether post was
helpful or not...

It is no big deal... I happened to know something you needed...

If you had searched (here or on the internet) you might have found the
answer yourself.

Have a nice day/night...
 
You just don't know I can now go to work tomorrow and sow my boss that I
figured it out without his help. You literally help me in a million ways.
It's night here in California where are you at?
 
Me too - San Jose area...

You can send an email if you need help in future... Just remove the first
part after my email id given here...

I am delighted that I could help you score points with your boss.... ;-)
 
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?
 
What's in A1?

Make sure it's a real date.
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?
Click to expand...
 
Back
Top