Advanced Conditonal Formatting

S

simsjr

Hello,

Want to see if there's a way I can make a cell turn red if the value it
contains is 15 minutes (or more) higher or lower than the value in the
adjacent cell.

Is this possible?
 
J

JE McGimpsey

One way:

Assume the entry cell is A1 and the "adjacent cell" is B1.

Select A1 and enter this cf:

CF1: Formula Is =ABS(B1-A1)>=TIME(0, 15, 0)
Format1: Pattern/Red
 
Top