I'm currently doing this with formulas and would like to automate it with VBA

sample.JPG


This is my format. Agent decision is what they assigned to the job, correct decision is what they should have assigned.

agent tagged a color but it wasn't correct - overtag
agent didn't tag a color but should have - undertag

For each tag I need to determine if the agent overtagged or undertagged that color, and put a number in that column. Then I need it to loop through all rows to the last.

I've googled this but not finding what i need.