under conditional formatting use the following (assuming that the date is in Cell D2)
Change condition 1 to: Formula Is
then enter
= D2 < TODAY()
Click the Format button and change the font color to Red (or whatever you like) and click OK
under conditional formatting use the following (assuming that the date is in Cell D2)
Change condition 1 to: Formula Is
then enter
= D2 < TODAY()
Click the Format button and change the font color to Red (or whatever you like) and click OK
Last edited by highbarger; 07-22-2009 at 05:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks