ExcelBanter - conditional formating using mod

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formating using mod (https://www.excelbanter.com/excel-discussion-misc-queries/224897-conditional-formating-using-mod.html)

gtslabs

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

Bernard Liengme[_3_]

conditional formating using mod

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

All times are GMT +1. The time now is 01:44 AM.