Conditional Formatting

[Gladys]

Is there a way to point out if a total to a formula is
not divisible by 10? Excel XP.

Example =sum(a1:a20) = 355. Is there anything I can do to
point that out?

 

[JulieD]

Hi Gladys

assuming your total is in A21
use "formula is" in the conditional formatting box and in the white box type
=MOD(A21,10)>0
then choose a format that you want to see if it's not divisible by 10

Cheers
JulieD

 

[Peo Sjoblom]

=MOD(A1,10)=0

where A1 holds the total
will return false for 355 and true for 360

 

[Gladys]

Thanks- But how do I put this in a data validation so
that it catches it and warns the input clerk?

Sorry for my ignorance!

 

[JulieD]

Hi Gladys

if you want the input clerk to be warned when she enters the 20th value this
can be done by using Data / Validation
choose Custom
enter
=Mod(A21,10)=0
change the Error Alert to "Warning" and write appropriate message

Hope this helps
Cheers
JulieD

 

[JulieD]

sorry should have said, click on cell A20 then data / validation etc