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 acco...
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.
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)
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?
Let's say the data start in row 2.
Use this conditional formatting formula:
=$B2-$A2>TIME(0,5,0)
