Comparing values in two columns, and highlight if not equal

Hi all:


I thank all of you for your previous help in other threads.

I have a simple macro problem. I have two columns (i.e. Columns A & E) with values than can be either numbers or strings.

I would like to know of a macro that can compare both columns to see is the values are equal, and if they are not, it would highlight the value in column B (the would be the wrong value) and would do this for several rows (a number of rows I can change when I use this macro in different sheets)

Thank you all for your help

Hi NBVC:

Thanks for the response.

I made a mistake in my previous post. "I'm comparing columns B & E, and if the values in each row are not the same (number or strings), the color of the cell for that value in Column B should change to red (or any other color)".

I could use Conditional Formatting as you mentioned, but I need a macro because this is actually a file I'll send to a friend who only needs to click on button, and the process is done automatically. Also I would like to see how is that done using VB code so I can learn a little bit more of Excel Macro and probably tweak it later on for a little different scenario.

If you (or anyone) could help me with this I'd appreciate it.

Thanks

If somebody could help me with this question I'd appreciate it.


Thanks