Excel - Conditional Formatting - Apply format if the % sum of a given set in a table is 100%
don't change the field of "=$D$2:$D$11" in Applies to, try this formula.
=SUMIF($B$2:$B$11,$B2,$D$2:$D$11)<>100%
Excel - Conditional Formatting - Apply format if the % sum of a given set in a table is 100%
don't change the field of "=$D$2:$D$11" in Applies to, try this formula.
=SUMIF($B$2:$B$11,$B2,$D$2:$D$11)<>100%