Hi all!
I hope that you are well? I have a formula issue that i'm hoping you can assist me with.
I have enclosed a very basic timesheet that runs from Sunday to Saturday and it shows time in / out and rostered hours. This is displayed for each staff member.
For each staff member there is a remarks box that contains a drop down menu. When each day is entered the drop down menu needs to be completed.
In cells A13:E16 are the rules of each rule type.
What i would like to do is for example if L (lateness is elected from the drop down box) excels flags that Time in / Time out and Rostered hours needs to be completed.
Once those cells are completed, i would like the highlight to disappear and only show the data in black and white again.
I have tried to do this via conditional formatting but got nowhere. I'm not sure about how i do about setting the mulitple rules.
An example trimesheet is attached for your viewing.
Thanks for all of your help!
JB
Bookmarks