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

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

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.

"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