Forum Discussion
Formula for time and color coding
Hi - Is it possible to make this where it is red only of the clock in time on is more than 5 minutes before the Tiger first Account Time and last account time and Dial pad first account and last account time. Example - ADP Clock in is 7:55am an the first account worked is 8:03.
I attached an excel spreadsheet and as you see I have color coded the rows in column B and in column E to indicate when the time is more than 5:00 minutes. Is there a code or formula that I can use to do this for future sheets?
- Hi Sergei,
I don't know how to do that. Okay - lets say column A has a time of 7:50 and Column B has a time of 7:56
How do I highlight or make the column A and B red because they are more than 5 minutes apart.- Highlight the cells of interest (e.g. column B and column E.
Go to conditional formatting and Add New Rule -> Based on custom Formula
type this for the formula:
=$B1=$E1
then set the formatting (e.g. background color red)- Thank you. I tried that but it didn't work. I wonder if it matters that I use the Microsoft 365 which saves online?
Unfortunately no sample file. If can't attach it to the post please share on OneDrive and share the link.
