conditional formating using mod

[gtslabs]

I am trying to conditional format a range of cells. The cell values
range from 0 to 360 deg.
I need to know if any cell is a multiple of 15 deg and if it is witin
+-0.5 deg from that multiple.

So for instance 269.5 to 270.5 would be formatted
359.5 to 0.5 would be formated, etc...

 

[Bernard Liengme]

How about: =OR(MOD(A1,15)<=0.5,MOD(A1,15)>=14.5)
best wishes