Hi everyone, I'm new to this site so please bare with me while I explain what I am trying to achieve.
I've created a table that shows the results of peoples hours of the week. To determine the total hours a week for an employee I have a column for Sunday - Saturday respectively.
In the total hours box I want it to display both the total hours of the week as well as having the cell change colours if the total hours go above a certain value or below a certain value.
i.e. if the total hours are 50+ then the box is red; if the hours are less than 44 then the box is green.
Is there anyway to set up a cell this way?
Any help would be grateful.
Thanks,
Kevin
Bookmarks