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

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

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

=($A1+$B1)<100%

--
HTH

Bob

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

wrote in message
...
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