Hi,
I have some experience with basic conditional formatting but overall I don't know much and would appreciated any help I could get.
I have timesheets that I need employees to fill out their start and end times. What I want to happen is if their shift is longer or shorter than 8.5 hours I want the cells with their shift time to change colour to Light red but with darker red text.
I have no trouble creating a total time row under each person which I can use conditional formatting to change colour based on duration of the shift by using =Cell<8.5 and =Cell>8.5 but I'm hoping to find a way to do this without using a total time row.
I have attached a sample timesheet, what I want to happen is that if the shift duration is more or less than 8.5 hours, cells B3:C4 will change to Light red with darker red font, is this possible?
Regards,
Alex
Bookmarks