Due Date

[kfcam]

Hi All,
I am new here and this is my second post concerning this problem. I will like to understand how to do the following:
I have 4 colums "Address, invoice #, Due Dates, date payed. I need to have all rows pertaining to dates due TODAY, to be highlited in red. I have a cell (=TODAY() ) which brings up the current date.
Please help.
Thanks in advance.
/keith
.

 

[Brian from Maui]

Have you tried this? If it doesn't what can we do to make it work for you?

http://www.mrexcel.com/board2/viewtopic.php?t=182774&highlight=

 

[Chitosunday]

Use conditional formating (format, conditional,condition 1 , formula,)
=A1<=TODAY()

then formmat the font as red