Conditional Formatting of a cell in Excel when it is divisible by decimals less than 0.5

[hannahmc8]

Conditional Formatting of a cell in Excel when it is divisible by decimals less than 0.5.
I want to highlight the cell if the amount entered is not divisible by 20pence, 10pence and 5pence. It works for £50, £20, £10, £5, £1 and 50p with
=MOD(A1,50)=0
replacing the 50 with 20 for £20, 10 for £10, 5 for £5, 0.5 for 50pence etc but when I try to repeat this for divisible by 20p as =MOD(A1,0.2)=0, it just doesn't work!
Thank you in advance,
Hannah

 

[moonfish]

Give this a try for the 20pence part:
=MOD(5*A1,1)=0

 

[hannahmc8]

Hi,
That's brilliant thank you!

 

[Jonmo1]

Could be a floating point precision problem...

try either

=MOD(ROUND(A1,2),0.2)=0
or
=MOD(A1,ROUND(0.2,2))=0


Do any of those work?