Please see attached spreadsheet.
In column G and H, there are words in each cell for each entry in A. I would like to write a vba code that says if the word in column G = the word in column H then in column I write ok (do for each entry). And if cell G does not equal cell H (for each entry), then highlight that entire row (from A:I). And I would like to do this for A7 down until the last row.
Any ideas?
Thanks for the help