Due Date

kfcam

New Member
Joined
Dec 4, 2005
Messages
2
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
.
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Chitosunday

Well-known Member
Joined
Jul 14, 2003
Messages
1,017
Use conditional formating (format, conditional,condition 1 , formula,)
=A1<=TODAY()

then formmat the font as red
 

Watch MrExcel Video

Forum statistics

Threads
1,118,524
Messages
5,572,640
Members
412,478
Latest member
MakeItWorkVBA
Top