Related:
- Conditional formating with If statements
- How many if statements can you nest - Guide
- If then statements in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
2 responses
OK< so what part are you stuck with: the conditional formatting, or the if statement? They are both the same thing. Make a formula and attach a format to it. Can you get the cell to turn one color yet?
OK, you have a nice start! The if statement is part of the formula to format, so with that being said, you just need to format the calculations of the worked time?
Nov 9, 2015 at 05:04 PM
I wish i could show you my sheet....
Time Requested Room # BedBoard STAT ISO Housekeeper Start Time Finish Time Total Clean Time Response Time Total Turn Time
12:35 4214 y Yes No jane 12:38 13:45 1:07 0:03 1:10
20:15 10147 April O'Neal 21:00 21:42 0:42 0:45 1:27
0:00 0:00 0:00
0:00 0:00 0:00
0:00 0:00 0:00