Conditional formating for if 2 cells in the same row have different values. 1300+ row spread sheet

[basher]

Hello,

I am trying to use excel to track a tagged inventory. I have a spread sheet that creates tags and records them allready. What I want to do is take the information on the created tags and then (tag number, product code, etc.) and the information from out inventory tag input system and past them in a new spread sheet. I then want to use condtional formating to highlight rows where there may be issues.

for each of the 1300 rows of my spread sheet I need:
column A checked against column E to ensure they are equal
column b checked against column D to ensure they are equal

I already had something similiar using unique formatting BUT the problem was it would chek the whole column not just on the same row.

Thanks,
Matthew Brown

 

[basher]

Oh and it's excel 07 I am using.

Matthew Brown

 

[Dartagnan]

A couple questions.

Are we talking about columns of numbers which can be summed?

Are you comparing row by row or just comparing the result?

 

[basher]

A couple questions.

Are we talking about columns of numbers which can be summed?

Are you comparing row by row or just comparing the result?

Row A to E comparison is a number.

Row B to F (not d like I said before) is also a nmber but is formated as text because it is a product code with periods for seperators.

Each row in both case must be checked row by row.

Thanks,
Matt

 

[Dartagnan]

A couple options for you.

First you could use match where the 0 tells it to look for an exact match. If the result is 1 then they match. An #N/A means they don't.
=MATCH(a1,e1,0)

or

do =a1-e1. If the result is not 0 then they don't match.

HTH.

 

[basher]

How would I apply this automaticlly to every row of the spread sheet?

 

[basher]

So,

I got it to work for the tag number when I tried it. Sorry about the post before I hadn't tried it yet when I posted that.

However for the product code match I cant get either to work:

It's flagging stuff but everything it flags are all matches

the product code I am using is 3 sets of three numbers seperated by periods.

ex. 100.100.100

The =B1-F1 formula does nothing
the =MATCH(B1,F1,0) only highlights in the one column I am selecting not both. Everything it has highlighted is a perfect match. and it hasn't highlighted any where the field it is supposed to match with is blank?

Also if I have 2 rows with the same content (except tag numbers) it will flag only the first one........

Kinda lost,
Matt

 

[basher]

GOT IT!

What I did was selected Column B then in conditional formating I used
>Format only cells that contain>Call Value>Not Equal to F1

Worked like a charm thanks! Only problem is after I did that I realized the inhouse inventory tag program I use adds 1 whitespace after each product code but if I go line by line and remove it the format works!!!! Don't suppose there is an easy way to automaticlly do that is there?

Thanks Matt