sorry - another Q. so i did try this & it works! my issue is that i can get
this to work on a whole new tab of data but not on my existing data tab. i
went through and deleted any existing condit formats & tried to implement
again and it still wont work. any thoughts on why? something is blocking it
from working but i dont know what...

thanks!

"T. Valko" wrote:

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??