Conditional Formatting change in azimuth

[Kirbstomp1287]

Hello all,

So I am trying to do conditional formatting to look for a greater than 30 degree change in direction. The issue I am running into is when you get between directions 340-020 it will always highlight that difference because obviously thats way more than a difference of 30 when doing it mathematically. But if your looking at a compass it may not be a difference of 30 degrees.

Example: Cell O5 shows direction 350 and cell AK5 shows 010. On a compass that is less than a 30 degree difference. Mathematically is is far greater than a difference of 30.

Is there any way around this??

Thanks for any help!

-Chris

[MrShorty]

I think most suggestions are to use the MOD() function =MOD(10-350,360) returns 20.

[Kirbstomp1287]

I think most suggestions are to use the MOD() function =MOD(10-350,360) returns 20.

So in the formula below where you put the MOD formula?

=AND(P5>=(ABS(AL6-P5)),ABS(AL6-P5)>30)

[MrShorty]

Around the ABS() function =AND(P5>=MOD(ABS(...),360),MOD(ABS(...),360)>30). 180 might be a better divisor than 360, depending on exactly what you are wanting to do.