Conditional formatting based on the sum of two cells (Excel 2007)

  • Thread starter Thread starter tomfabtastic
  • Start date Start date
T

tomfabtastic

Hello,

I have two cells which must contain percentages that sum to 100%. I
can apply conditional formatting for when either cell is < 0% or >
100%. But how do I apply conditional formatting for when the sum of
both cells does not equal 100% ?

Thanks,
Tom
 
=($A1+$B1)<100%

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top