Conditional Formatting

  • Thread starter Thread starter Gladys
  • Start date Start date
G

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?
 
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
 
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!
 
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
 
Back
Top