Match Inconsistant entires bewteen days
 

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?

Match Inconsistant entires bewteen days
 

Use Format | Conditional Formatting

Try setting it up this way:
Select cells B1:D4
Format | Conditional Formatting
In the drop down that starts out saying "Cell Value Is" use the arrow and
choose the entry that says "Formula Is"
in the entry next to "Formula Is" type
=B1<H1
Press the [Enter] key
and set the formatting you want (use the "Patterns" tab to change the
background color when the test is met).
That should tell you when the values differ without regard to what is in
column A.

"JMay" wrote:

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?