conditional formatting of date

R

raj

i have a column 'target date' in my excel sheet. this column contains my
target date for my jobs. i want to display the dates in red color for those
entries that are older than today.

i.e. if today is 12/28/2006
target date
12/29/2006
12/26/2006 -- this cell in red

how to do it automatically? Thanks in advance
 
M

Muhammed Rafeek M

if u want format in cell A2, select A2
select Formula from Format menu - > Conditional format
and put formula which i mentioned below and select format.
=E3<TODAY()
then click okay
afer that u can use format painter to apply for other cell also

pls do rate
 
R

Ragdyer

Say that the "Target Date' column is Column A, from A2 to A100.

Select A2 to A100, with the focus in A2 (colored white), then:
<Format> <Conditional Format>
Change "Cell Value Is" to "Formula Is", and enter this formula:

=A2>TODAY()

Click on "Format", and choose a font and/or pattern color of your choice.
Then <OK> <OK>.
 
Top