Conditional Formatting Dollar Amounts

[Delfinus25]

I have a column where dollar values can be entered. Could range from .01 to 3.00. I need to highlight anything that doesn't end in a 0 or a 5. I thought I could use a RIGHT formula, but it doesn't work as all the 0's are not included in this.

Can anyone assist with the correct formula for this conditional format?

Thanks!

 

[njimack]

=round(mod(a1*100,5),0)=0

 

[Delfinus25]

I thought the MOD method was my path, but couldn't nail it down. I did have to change it to <>0, as I want to highlight those that DON'T end in 0 or 5.

=ROUND(MOD($L2*100,5),0)<>0

Thank you so much for your help with this!!