Compare the text in cells between 2 columns - macro?

[mrafiq44]

I have 2 columns F & G - Column F has text in 800 rows derived via vlookup for another sheet. Column G is a simple copy and paste from a word document.
Column F for example the cell says: Invoice is approved by CEO
Column G for example the cell says: Invoice is approved by CFO and CAO
What i want to see is the difference i.e. the word CFO and CA0 which are the difference from column F in column G highlighted.
Is there a macro that can run and show me that?
Also in column H - can there be a formula comparing the 2 cells in column F and G and saying "yes" there is a difference, remember exact may not work because of formatting from vlookup not being the same with the alignment, etc.

Any help here would be appreciated.

 

[D_Duck]

If you just want to compare a cells value in col. F to col. G, a formula in col. H as follows will do that: =if(F3=G3,"Yes","No")