Hi,
I've tried searching the forums but I cant quite find what I'm after.
Is there a way to highlight cells that consecutively contain the same data, but only if the data is entered across 20 columns consecutively?
We have to track driver hours to ensure they are taking a break after 5 hours of driving. We have a spreadsheet that our admins use to assist with monitoring but it requires them to enter an 'x' in each column for hours worked, breaks and non-drive time. I want the 'Work time' rows to automatically highlight if more than 5hrs (20 columns) have an 'x' inputted so they don't have to go back and manually count each entry.
I've attached an example spreadsheet. You can see in row 5 that the driver worked 5.5hrs before taking a break, in this instance we would want columns AF-BA to be highlighted, or if its easier, columns AZ-BA as it still shows that the driver exceeded the allowable work hours. Is this possible?
Bookmarks