conditional format a date in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use conditional formatting to show when a date is less than 30
days in the future. When I use "cell value" "is less than" "="Now()+30" all
the dates change.
 
I am trying to use conditional formatting to show when a date is les
than 30
days in the future. When I use "cell value" "is less than" "="Now()+30
all
the dates change.

lose the quotes in the condition =Now()+30

Unless you mean between today and 30 days in the future in which cas
=now() would be the first condition and =now()+30 would be the second

Also now() returns the date and time is this what you require ofte
today() which just returns the date is preferable

Regards

Da
 
Thanks for the quick response, actually, the Excel (computer) puts the quotes
in. I did finally find a Discussion from 2004 that helped also by using
Today() instead of Now() and got it to work.

Al
 
If this is still open:

Your date in B1:

select format-->conditional format
select "formula is"
type =B1<today()+30
click "format"
select the formatting you want
click ok
click ok
copy B1 and "paste special-->format" into all cells that need
formatting.


Is that what you wanted?

Hans
 
Back
Top