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...
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)
