Forum Discussion
Solved
conditional formatting based on 2 seperate rules
I have just started a new job where I'm responsible for shift planning. I've set up the roster to count how many people we have on shift each day. If we have more than 6 people on shift Sun - Thu I...
See the attached workbook for alternatives.
The first formula worked but the second didn't.
If you look at column D the "5" indicates someone is on shift.
The count is at the bottom highlighted in green. D4-D11 =7 people on shift so it turns green.
But it should still be white as it's a Friday and it needs to exceed 8.
Thanks for your help.
See the attached workbook for alternatives.
- OMG SnowMan55 I don't know how but this worked!!! I used the last option the SWITCH formula and HEY PRESTO it changed green when I needed it to. I didn't really understand the formula or the instruction but it works. Thank you so much for your help!!!