conditional formula with date
Thank you, John, for the info.
Loc
"John C" wrote:
What Mike is saying, after you do the conditional format for the 1 cell, then
highlight the entire selection, go to Conditional Formatting, and press OK.
So long as your cell refernce is not anchored (with $'s), then it will
progress accordingly for all your range.
--
John C
"Loc" wrote:
Mike,
The formula you wrote is for one cell. If I want to apply this formula to
whole column, should I replace A1 with A1:A5000? Thank you for the help.
Loc
"Mike H" wrote:
Hi,
For closer than 30 try
=AND(A1<TODAY()+30,A1=TODAY())
and for overdue
=A1<TODAY()
Mike
"Loc" wrote:
I have a delivery date column with mmm-yy format. How can I write a
conditional formula so that the date turns yellow when it's due in 30 days
and turns red when it's over due? Please help!
|