I have a roster where i want to implement conditional formatting.
If you see my roster below, you will see the green and red fields. When any number up to 8 is entered in the “Normal Hours” column, I want it to be GREEN and if above that, i want it to be ORANGE. And for the Overtime ours column i want it to automatically go RED when any number is entered.
For the TOTAL HOURS box, i want to use the Icon set and utilise the tick and apostrophe icons. When the total hours are ‘213’ it’s always a green tick but if it’s less than 213 or more than 213 i want it to be a yellow apostrophe.
Can someone assist with this setup please?