Conditional formatting with colors

Bookmaster

Board Regular
Joined
Mar 22, 2014
Messages
85
Office Version
  1. 2021
Platform
  1. Windows
Hello,

I am having problems with conditional formatting. I have dates and first 2 letters of days and I would like to color just cells with Su and number bellow with blue and cells with Sa and numbers bellow with red but without success :(
Here is part of my table:

1633007260749.png


So I would like conditional formating to look from D7 up to AH7 and if finds Sa to color with blue cell with Sa and number bellow. For another part, for cell with Sa I can do it according to solution for previous one.
At the end I would like to have it all like this:

1633007470336.png



Thanks in advance for help.

Regards
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
How about
+Fluff 1.xlsm
DEFGHIJKLMNOPQ
7SaSuMoTuWeThFrSaSuMoTuWeThFr
81234567891011121314
Main
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D7:Q8Expression=D$7="Su"textNO
D7:Q8Expression=D$7="Sa"textNO
 
Upvote 0
Solution
That is great but I have excel 2013 and don't have or actually don't see a table for conditional formatting like that one.
My steps are:

1. Mark cells for conditional formatting
2. Conditional formatting - New Rule
3. Use a formula to determine which cells to format
4. and I am stuck here :(
Whatever I do I am not getting what you made above.

Help me, please

Regards
 
Upvote 0
Glad you sorted it & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,214,599
Messages
6,120,449
Members
448,966
Latest member
DannyC96

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top