There are two tables with identical columns - 5 columns each. A column can have text or numbers in them. How do do a compare so that I compare each cell value of table1 to table2 for the same row and column and if there is a difference, I highlight or indicate it in both tables…for example
Please see the attached….how do I do that in vba. Can the same by done via formulas?