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
|