Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting problem
Good evening, I am working with Excel 2002
I am trying to put a conditional format on a cell using data calculated in another A2 has the data - cell is formatted "ddd" to display day from date value in A1. I want A3 to change colour when A2 dispalys "Fri" but =A2="Fri" does not work or A1 has date eg: 01/07/2005 A2 =A1 format is ddd (Displays "Fri") A3 I want to conditional format but =A2="Fri" doesn't work. How do I make it look at the value returned not the formula. I have read many threads but cannot see the answer. Any help would be appreciated, thanks Regards Bryan |
#2
|
|||
|
|||
"Bryan" skrev i en meddelelse ... Good evening, I am working with Excel 2002 I am trying to put a conditional format on a cell using data calculated in another A2 has the data - cell is formatted "ddd" to display day from date value in A1. I want A3 to change colour when A2 dispalys "Fri" but =A2="Fri" does not work or A1 has date eg: 01/07/2005 A2 =A1 format is ddd (Displays "Fri") A3 I want to conditional format but =A2="Fri" doesn't work. How do I make it look at the value returned not the formula. I have read many threads but cannot see the answer. Any help would be appreciated, thanks Regards Bryan Hello Brian One way is to use this formula in conditional format: =(WEEKDAY(A1)=6) -- Best Regards Leo Heuser Followup to newsgroup only please. |
#3
|
|||
|
|||
Good on you Leo! I have been playing with this for hours - have a great day
Regards Bryan "Leo Heuser" wrote: "Bryan" skrev i en meddelelse ... Good evening, I am working with Excel 2002 I am trying to put a conditional format on a cell using data calculated in another A2 has the data - cell is formatted "ddd" to display day from date value in A1. I want A3 to change colour when A2 dispalys "Fri" but =A2="Fri" does not work or A1 has date eg: 01/07/2005 A2 =A1 format is ddd (Displays "Fri") A3 I want to conditional format but =A2="Fri" doesn't work. How do I make it look at the value returned not the formula. I have read many threads but cannot see the answer. Any help would be appreciated, thanks Regards Bryan Hello Brian One way is to use this formula in conditional format: =(WEEKDAY(A1)=6) -- Best Regards Leo Heuser Followup to newsgroup only please. |
#4
|
|||
|
|||
"Bryan" skrev i en meddelelse
... Good on you Leo! I have been playing with this for hours - have a great day Regards Bryan You're welcome, Bryan, and thanks for the feedback :-) Regards LeoH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
Conditional Formatting Problem | Excel Discussion (Misc queries) | |||
Conditional Formatting problem | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Count and Sum with Conditional Formatting Problem | Excel Worksheet Functions |