View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gtslabs gtslabs is offline
external usenet poster
 
Posts: 54
Default conditional formating using mod

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...