Each day I receive e-mails from my branch stores
In the body of the e-mail the sender lists

On Say Thursday they report:

Gas Express, 1.90, 2.00, 2.10
Texaco, 1.85, 1.90, 1.95
BP, 1.92, 1.97, 1.99
Kroger, 1.85, 1.87, 1.95

I am able to capture and get this into Excel
into Range A1:D4

At day end I move the A1:D4 to say G5:J8

On Friday say they report:

Gas Exp, 1.90, 2.00, 2.10 << Note they shortened the name to just Exp
Texeco, 1.85, 1.95, 2.05 << Note they mispelled Texaco with an "e"
BP460, 1.92, 1.97, 1.99 << Note they added 460 indicating on Hwy #460
Kroger, 1.85, 1.89, 1.95 << No chg - OK !!

I need to conditionally format and highlight YELLOW my Friday data (this data)
now in Range A1:D4 -- only when a price has CHANGED from the day before
(which is in Range(G5:J8).
Note price change in 2 and 3 of Texeco
and price change in 2 of Kroger

I am able to conditionally highlight -- but having a REAL problem
trying to work out the INCONSISTANCIES between the names being entered by
the senders.

Can someone cast some light or thoughts on how to best clear this problem?