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

[thewrathful]

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

[royUK]

Try this formula in the Conditional Format

=MOD(A1,5)>0

[martindwilson]

i think that should be
=mod(a1,5)=0 if you want all that are divisible by 5 highlited if its the other way around highliting all those
that are not then just =mod(a1,5) will do

[thewrathful]

Thanks guys! Good work.