date alert color code

[jackson5]

I have an excel sheets that has a column that lists dates of medical licenses. I wish to have a formula that will change the color of the field when the date due is less that 30 days away from expiration. I hope I am clear with this. e.g medical license expires on 9/30/11. I want the field to change to a color in 30 days before to alert me I need to request a new license.

 

[Blade Hunter]

You should use conditional formatting for that.

Cheers

Dan

 

[Michael M]

As Dan mentioned you will need to use CF
When the CF Dialog box is open, select "Formula is" in the LH dropdown box
and then in the right hand dropdown you will ned a formula like

=$B$1<(TODAY()-30)

which basically says if cell B1 is less then Todays date minus 30 days then apply the chosen formatting.
You can then copy the formatting to other cells

HTH