conditional formatting of date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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>.
 
Back
Top