Macro to check values on two cells should be equal

Hi all

I have cells that they're values should be equal B6=B11, B7=B12, B8=B13, E6=B14, E7=B15, E8=B16, I want a macro that if the values are not equal then the background should be RED and a pop up message "The values should be equal".

Any help on how to do this would be very much appreciated!

Thanks
Blokeman

Like this:

Please Login or Register  to view this content.

Hi stnkynts

Thank you for response, is it possible that only if B6, B7, B8, E6, E7 and E8 have value then that's the time that it will check the other cells? The priority is always cells B6, B7, B8, E6, E7 and E8, if this cells are blank then it will not check the other cells. Example: if B6 is empty and B11 have a value of 104 then do nothing but if B6 have a value of 103 then it will check B11 if they have the same value. Hope this help, sorry I forgot to mention this on my first post.

Thanks
Blokeman

Can this help?

Please Login or Register  to view this content.

Hi John

Thanks for your response.
This is what happened when I run your code:

-when there's values in cells B11:B16 and B6:B8, E6:E8 is empty, no message no color- Approved

-when there's values in cells B11:B16 and I entered values in B6:B8, E6:E8 not equal to B6:B16 then I only got a message and no color. And when all cells have values (not equal) and I clear B6:B16 then I got a message and color only on B11:B16. On this one can both cells have color, only if not equal but not if both is empty.

Hope this help.

Thanks
Blokeman

See amended code:

Please Login or Register  to view this content.

Hi stnkynts

When I run the amended code:

-When values in B6 and B11 is not equal I got message but no color on both cell. There should be color when both cells value is not equal.
-if I delete the value in cell B6 then it turn red. If cells B6:B8, E6:E8 is empty and cells B11:B16 have value then do nothing (no message and no red color background).

Hope this help.

Thanks
Blokeman

Post your workbook cause it works fine for me

@ stnkynts

It is because you are using conditional formatting to color the cells. The conditional formatting is taking precedence over the macro's cell coloring. Conditional Formatting and VBA do not work well together. There may be a way to recognize the conditional formatting, remove it, and change the cell color and if there is I don't know how to do it. Best of luck to you.