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

[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

 

[Bob Phillips]

=($A1+$B1)<100%

--
HTH

Bob

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