I have a spread sheet that looks like this
Project Well Hours
Lewis 1 12
Lewis 2 3
Lewis 1 9
I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24 then highlight those rows in red. Any suggestions?