Conditional Formatting?

[Guest]

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

 

[Max]

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$1>TODAY())
Format to taste and OK out

 

[Guest]

It works! thanks v much!

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$1>TODAY())
Format to taste and OK out

 

[Max]

Glad to hear that !
You're welcome ..