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