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?

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?