Conditional Formatting

Hi there,

 

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?

 

By: Davor

Leave a Reply

Your email address will not be published. Required fields are marked *