Bookmaster
Board Regular
- Joined
- Mar 22, 2014
- Messages
- 85
- Office Version
- 2021
- Platform
- 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:
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:
Thanks in advance for help.
Regards
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:
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:
Thanks in advance for help.
Regards