Hello. I have a worksheet with Names down the left side, a blank row, and then number values. I am really stumped as how to step through. I have attached a file as an example.
What I need is to add the values from each column if a person is listed twice, then if the number is over 100, set the interior color of the cell to yellow. I know this could be done with conditional formatting but the other parts of the workbook is so large and slow I wanted to set the formatting statically with VBA.
For example, in my worksheet Alex is listed twice in column D. The sum for him in column D is > 100. So set the interior color for those cells to yellow.