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

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

1 response
Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

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

26 responses
this account will be disabled in 28 day you only have 28 days left to request a
Chandrakantmahire -
Treasurelove -

2 responses
This account will be disabled in 1 day Are you sure that you want to log out? Y
Usman -
dwebb -

1 response