XL2000, CF and List Comparisons

[LPS]

Many thanks to Sean Timmons for the Vlookup solution.

Using the same Excel 2000 worksheet, (I have two lists of data, both two
columns.
The first list is named "OurOrders" and contains an Order Number (Column B)
and Dollar Amount (Column C). The second list is named "TheirOrders" and
contains an Order Number (Column E) and a Dollar Amount (Column F)), how do
I
compare the two Order Number columns such that if Column E is not the same
as Column B, or is empty, Column B is formatted? Can I do this with
Conditional Formatting?

All help is greatly appreciated.

 

[Pete_UK]

Do you mean that you want to compare B2 just with E2, then B3 with E3
etc., or do you want to compare B2 with all of the numbers in column E
to see if there is a match, then B3 with all of column E etc.?

Pete

 

[ShaneDevenshire]

Hi,

If you want to do a cell by cell comparison the formatting would llke this:

In conditional formatting choose Formula is from the first drop down and
enter
=OR(B1=E1,E1="") in the next box and then apply the desired formula.

 

[LPS]

Sorry, I was not very clear.... that's what happens when you are doing too
many things at once! I hope this helps...

In the sample data below, I want to be able to compare the order numbers in
Column B with the order numbers in Column D and if there are any differences,
to highlight those differences. For example, below, the only difference
between order numbers is the last one. I want to highlight the different
order numbers with one colour (say, red). At the same time, I also want to
compare the dollar values in Columns C and E and if there are differences in
the dollar values, I want to highlight both those and their corresponding
order number with a different colour (say, blue).

B C D E
999888 $10,050.00 999888 $10,000.00
888999 $10,000.00 888999 $10,050.00
777666 $12,000.00 777666 $12,000.00
666666 $60,000.00

I'm guessing I need two conditional formats but I have gotten myself totally
confused as to how to do this.

If you can help I would be very grateful (and I am sure my head would stop
pounding!).
Thx,