Conditional Formatting Formula for highlighting Azimuth.

[Kirbstomp1287]

Hello all,

I have a very tricky question and one that excel may not be able to handle without some crazy formula and that is dealing with Azimuth directions (Degrees on a compass).

So what I am trying to do is highlight anything that is more than +/- 30 degree difference in direction. The issue is when you get to the Northerly directions. When going from a Northwest direction like 350 to a Northeast direction like 010 (10 degrees) the math will always show that this is greater than a difference of 30 because mathematically is a far more than a difference of 30. But when looking at a compass that 350 to 010 is not a difference of more than 30 degrees it is only a difference of 20 degrees.

I have attached an example excel file to this post for reference.

On the Direction 1 table I want to highlight if there is a 30 or more degree difference between the data in the Direction 1 and Direction 2 tables. The conditional formatting formula I currently have in place does not work obviously but it is there for reference.

Thank you for any help in advance!

-Chris

[tatoon]

Try this in P5:

Please Login or Register  to view this content.

The formula can be refined, but it gives you the distance between the two angles.

[Kirbstomp1287]

Try this in P5:

Please Login or Register  to view this content.

The formula can be refined, but it gives you the distance between the two angles.

That works to find the difference but is there a way to translate that into a conditional formatting formula to get it to highlight if it is +/- 30 degrees? I know I could just add a new column and just get the raw number and use that but it would be much cleaner to just have a conditional formatting formula to highlight the original cell.

Thank you for the help! If I can't find a way to do it with conditional formatting this will be really useful!

[tatoon]

You can create a formula based conditional formatting.

Just wrap the formula I wrote before in a: =If(formula>30,1,0)

[Kirbstomp1287]

You can create a formula based conditional formatting.

Just wrap the formula I wrote before in a: =If(formula>30,1,0)

Thank you that worked! Thank you very much for the help! I spent way to long trying to figure that out before coming here lol.