Date formula
Please don't go Im tring this now
"Sheeloo" wrote:
First condition would be same
For second use
=A1<DATE(2008,9,1)
"J" wrote:
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.
"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
|