Conditional Formatting?
 

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

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

It works! thanks v much!

"Max" wrote:

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

Glad to hear that !
You're welcome ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Dolphinv4" wrote in message
...
It works! thanks v much!