I have a column where all the numbers are multiple of 5.
But, I want double check that all the numbers in rows are
multiple of 5. I used =if(mod(a1,5)=0, true, false)-(I
used inverted commas for true and false but in my current
keyboard this key is not working). So, I get reply true or
false. Its working but I want to change the colour of the
number which is false according to the condition applied.
How can I use colour in formula.
Any help appreatiated

Many thanks
sanjay