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 |
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 |