Changing date font

Posted by Scott on December 27, 2000 12:07 PM

I am trying to do the following:
If a date in a certain column is within 30 days of the actual date I want to change that color to RED BOLD.
Is there a way to do this.

Thanks

Posted by Tim Francis-Wright on December 27, 2000 12:25 PM

In Excel 97 and later this is easy:

Select the cells for whichyou want to have the
conditional formatting (I'll assume that the top
left of the range is cell B3). In the worksheet
menu, select Tools, then Conditional Formatting.

Condition 1 should be =(ABS(TODAY()-B3)&LT;=30)
Hit the Format... button, and select Bold text
and a Red font under the Font tab.

That should do it!

Posted by Scott on December 27, 2000 12:55 PM

This works if I have todays date marked somewhere, but I am trying to do it without. I just want to put a date into a cell and if it is 1 to 30 days after todays date it will automatically go RED. For example I put in 1/5/01 it should go RED.

Thanks

Posted by Tim Francis-Wright on December 27, 2000 1:16 PM

To get red and bold for the 30 days before and
the 30 days after today's date (what you originally)
asked for,
Condition 1 should be =(ABS(TODAY()-B3)&LT;=30)

To get red and bold just for the 30 days after
today (what you just asked for),
Condition 1 should be =(AND(D14-TODAY()&LT;31,D14-TODAY()>0))

This just relies on thr built-in TODAY() function,
not on any other reference in the workbook.

Good luck!

Posted by Scott on December 27, 2000 1:40 PM

Thank you very, very much.