Displaying an Automatic Error Message

I'm attempting to have an error message automatically display in a cell. The error message should display when a group of cells with percentages in them do not add up to 100%. How is this done?

HI

One way is to use an IF statement to show the error message when the sum is not 100%, and use conditional formatting to make the cell obvious.

Put a formula like
=if(sum(yourrange) <> 1, "PROBLEM HERE","")
in a cell (say C1) then use conditional formatting on C1 to highlight the cell when the result is PROBLEM HERE.


HTH

rylo