Count all columns per row basis and = 100

Hi all,

I will need to sum a daily routine for users to input their commitment on the type of exercises they had.

Each row (per day) with multiple columns (type of exercises) should have predefined values from (0, 10,20,....,100) where all these will be added per row with the columns and should not exceed 100. Anything less or greater than 100 will have a pop out window to prompt for error.Count_input_perRow_equalto100.jpgTest.xlsx

Basically, i will the follow logic flow:-

1) user to input the range of predefined number via a drop down menu
2) user select a pre-defined value range from rows of 8 to 12
3) user defined value in each horizontal row will be automatically computed
if defined result is less or greater than 100, an error box will be shown

Please advice how i can achieve this.

Thnak you very much.

You could simply use conditional formatting to color the cell a certain color, say red, if the number in G8 doesn't equal 100.

Enter the following formula in G8: =sum(a8:f8)

Then, select cells g8:k8 (making sure G8 is the highlighted cell in that selected range), create a new Conditional Formatting rule using a formula, and enter: =G8<>100 as the formula. Then select a cell fill format of any color or other format you want and hit OK.

- Vince