Quote:
Originally Posted by Jamal NUMAN
If the subtraction of two angles is minus, then the value is not given!
|
That's because you're actually working with a time format and times cannot be negative. However, you can use:
=ABS(C11-C9)
and combine this with a conditional format that uses the formula =C11<C9 and colours the cell accordingly.