Forum Discussion
Shrey10
Aug 10, 2023Copper Contributor
Break Schedule
I am trying to make a break schedule in cell C8 name is OUT and D8 is IN how to get the the both cell turn red when the time goes over 36 minutes. I tried many different way but only one of ...
HansVogelaar
Aug 10, 2023MVP
Let's say OUT is in D8 and down, and IN in E8 and down for BREAK 1, up to row 100.
Select D8:E100.
D8 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=$E8-$D8>TIME(0,36,0)
Note the $ before the column letters D and E.
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Similar for BREAK 2, with only the column letters changed.