Code to compare if values in two cells are the same, if yes highlight both cells green

[fah]

Hi, I don't know VBA, but I urgently need to have simply macro which works like:

1. Check does values in cells eg. A2 and B3 are the same.
2. If A2=B3, then set green background in both cells.
3. If A2 has different value than B3, then set red background of both cells.

Could anybody please write steps above in efficient VBA code for Excel? Many thanks!

[abousetta]

Maybe try this:

Please Login or Register  to view this content.

abousetta