Date customization

  • Thread starter Thread starter Kyle
  • Start date Start date
K

Kyle

In a column of dates, how do I program the dates over 30
days old (separate cell with "today()" already entered) to
be red?

Explained another way...
top cell: today()
then a list of various dates and I want those that are
more than 30 days older than the the current date to be in
red.

Thanks for any input!
 
Hi
try the following:
- select your dates e.g. A1A30
- goto 'Format - Conditional Format
- enter the following formula
=A1>TODAY()+30
- choose a format
 
Hi

You can do this with Conditional Formatting.
Select your column and go to Format / Conditional Formatting. Use Formula
is and enter:
=A1<$A$1-30
in the box
 
Thanks, much appreciated!

-----Original Message-----
Hi

You can do this with Conditional Formatting.
Select your column and go to Format / Conditional Formatting. Use Formula
is and enter:
=A1<$A$1-30
in the box

--
Andy.





.
Click to expand...
 
Thank you!

-----Original Message-----
Hi
try the following:
- select your dates e.g. A1A30
- goto 'Format - Conditional Format
- enter the following formula
=A1>TODAY()+30
- choose a format

.
Click to expand...
 
Back
Top