[SOLVED] Conditional formatting numbers that go up in 5's

Hello,

I am trying to use a cond. format that will highlight a cell if it is eg. 5,10,15,20,25,30,35,40,45,50 etc

My set-up is like this:

A1
25

B1
Revert to macro

So because A1 is a multiple of 5, that cell and B1 needs to be highlighted. (all the numbers have a description next to them that i would like highlighted aswell)

I highlight both cells and then i do a conditional format of 'Formula Is' and then '=IF=$A1=5;10;15;20;25' but it yields no results.

Can anybody modify my formula to make it work?


Thank you