Previous Topic Next Topic

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 response

Answer 1 / 1
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses