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


"raj" wrote:

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

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:

=A2TODAY()

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"raj" wrote in message
...
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