Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |