Advanced Conditonal Formatting
 

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?

Advanced Conditonal Formatting
 

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





In article ,
simsjr wrote:

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?