Conditional Formatting help - colour and days

Closed
Bryony - Aug 26, 2010 at 09:38 AM
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
- Sep 2, 2010 at 07:12 PM
Hi

Hoping for some help!

Currently cell A1 has the day of the week in it (not automated)

I want cell J8 to be white if the day in A1 says Wednesday or a Friday. If it's not Wed or Fri, it needs to be grey.

Can anyone help? Am finding it really hard! I know it's conditional Formatting but...!

Am using Excel 2003.

Thanks
B

1 reply

RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
25
Sep 2, 2010 at 07:12 PM
In cell J8, set the conditional formatting to be:
Condition 1: Formula Is: =IF(A1="Wed",TRUE,IF(A1="Fri",TRUE,FALSE))
Condition 2: Formula Is: =IF(A1<>"Wed",IF(A1<>"Fri",TRUE,FALSE))

Choose your colours accordingly.
0