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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"gtslabs" wrote in message
...
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...