Select the entire sheet (Press CTRL+A)
In the conditional format dialog:
For condition 1, make it as:
Formula is: =AND(A$1<0,A$1TODAY())
Format to taste and OK out
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Dolphinv4" wrote in message
...
Hi,
I have a table like this:
1/6/05 1/7/06 1/8/05 1/9/05
xxx yyy zzz aaa
bbb ccc ddd eee
I want the columns which is more than today's date to appear in red, ie,
the
column "1/9/05" will be in red since today is 22/8/05. I used conditional
formatting before but that is for using only 1 column. I don't know how to
manipulate conditionaly formatting for this case. Is there a way? if not
by
using conditional formatting then how can i do that?
Thanks!
Val