View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Validation of a sum

I would apply conditional formatting for the cell containing the SUM (say A2)
with formula
=AND(A2<0,A2<100)
and red color!

Regards,
Stefi

€˛Jane€¯ ezt Ć*rta:

I want to validate that a sum of cells is 0 or 100. How do I do that?
--
Jane