conditional formatting issue

G3N3RAL31

New Member
Joined
Aug 18, 2018
Messages
3
I am trying to utilize a break gap spreadsheet and add conditional formatting to it to highlight when an employee takes their break within a window of time and for the CF to color highlight anyone outside of the specific threshold of time.
example:
employee's 1st break is scheduled at 7:00
window to review is set at 6:45 to 7:45 (variable range)
employee 1st break is set for 20 minutes in length
CF to read time between range and color cell range anything greater than threshold (20 minutes)

Not able to update image of the spreadsheet.


<tbody>
</tbody>
Adjust time range in yellow by shift
Site ID1st Break6:55to7:3020
Shift Date10/31/2018Lunch9:45to10:4535
AreaA1Orderfilling2nd Break12:45to13:4515
Shift1
Time Gap8
Indirect Times Pick Gaps First PickLast Act
Associate CodeStartTimeTrip TripTimeTripTimeGap TripTimeTripTime

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
505 ISTART 4:0010 19747:0018137:2121 18864:08178713:34
IBREAK1 7:0220 201510:01201510:3534
ILUNCH 10:0135 193612:45178713:0520
IBREAK2 12:5415
IENDAY 13:345

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>


variable range is in cells O3 & Q3 (6:45 to 7:45)
break range is pulled to columns I & K
break gap difference is column L
threshold time is R3 (20 minutes)
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,214,956
Messages
6,122,465
Members
449,085
Latest member
ExcelError

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top