VBA Code to highlight discrepancies

[lahuber21]

Hi! This is my first thread ever. I've recently started teaching myself VBA by watching videos online. It has already helped many tasks at work!

What I am currently trying to figure out is:

I need my values in column E to be highlighted yellow if they do not match the total value of column H, I, J and K added together.

For example, If cell E3=10 and cell H3=8, I3=2, J3=0, K3=1....cell E3 should be highlighted yellow because cells H,I,J,K do not equal 10.

Thank you!

 

[Joe4]

Welcome to the Board!

One way is to use the "Use a formula to determine which cells to format" option of Conditional Formatting.
Just select cell E3, go to Conditional formatting and choose the "Use a formula to determine which cells to format" option, enter the following formula:
=E3<>(H3+I3+J3+K3)
and then choose your yellow background color.