Conditional formatting problem

B

Bryan

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
 
L

Leo Heuser

Bryan said:
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
Click to expand...

Hello Brian

One way is to use this formula in conditional format:

=(WEEKDAY(A1)=6)
 
B

Bryan

Good on you Leo! I have been playing with this for hours - have a great day

Regards Bryan
 
L

Leo Heuser

Bryan said:
Good on you Leo! I have been playing with this for hours - have a great
day

Regards Bryan
Click to expand...
You're welcome, Bryan, and thanks for the feedback :)

Regards
LeoH
 
Top