Try this:

Assume your dates are in the range A1:A10

Select the range A1:A10
Goto the menu FormatConditional Formatting
Formula Is: =AND(ISNUMBER(A1),A1<=TODAY())
Click the Format button
Select the Font tab
Select Bold and Red
OK out

Biff

"tkg" wrote in message
...
love excell but still so much i dont know, can some smarty out there
please
help?

i am using excell to track tasks to be done. i have a column of "due
dates"
and would like that when i open the file each day for the items that are
due
that day or prior to display in red bold. would that be done through
conditional formatting?

i got it to do it with a static date but not change on a daily basis as
the
date changes.

make sense? can anyone help??