I have a number of cells in each row of a sheet where the user will enter percentages. I need to find a way to highlight all the cells in that row (columns A, C, E, G, I) if the total of all the cells <> 100%. Ideally I only want the cells highlighted after the last entry has been made, so if the user enters 20% in A2, 20% in C2, 20% in E2, 20% in G2, and 10% in I2, then all these cells should be highlighted to show that the total of these cells doesn't = 100%. I don't want the data validation to kick in until all the cells have entries. The user will be asked to enter 0% if there is no percentage, so will be asked to complete all cells.

This needs to work for each row in the sheet.

Many thanks