Highlight cells if they don't match one of two cells (macro)

**apollo753** · 09-12-2012, 10:00 PM

I have a macro that marks correct answers based on the correct value in B2 - B17 and AI2 - AI17 being the wrong answer.
Also if B2 - B17 is entered incorrectly that cell color turns red. If the answer is correct the cell color turns yellow and is added up at the bottom.

What my macro does not do is change the cell color to red if C2 - AI2 does not match B2 or AI17. Also if AI2 - AI17 is not entered correctly the cell color should change. Here is the macro. Also a file is attached with the macros. When the changes are made to the macro it should find mistakes in the attached file, some of the cells that are wrong are C2, D2, C3, D3, C15 there are others that are wrong.

Please Login or Register  to view this content.

**apollo753** · 09-19-2012, 11:09 AM

Anyone have any ideas for this?

**FDibbins** · 09-19-2012, 12:03 PM

you dont need a macro to change the cell color, conditional formatting wll do that for you easily.

see the attached and let me know if that is what you wanted?

**apollo753** · 09-20-2012, 12:04 AM

Capture.jpgSorry I need to use a macro as conditional format breaks other macros on my excel sheets. This is a small potion of what I do.
I have attached a picture of what the macro should return when working correctly. I shortened (removed columns) just to make it look better for the example.One thing to remember if C:G do not match B or H they should turn red. If B:H do not match C, C should turn red. If B:H do not match G, G should turn red.