View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LPS LPS is offline
external usenet poster
 
Posts: 108
Default XL2000 CF and Comparing Lists

Using Excel 2000, on one sheet, 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 lists and have the differences highlighted through
Conditional Formatting?

All help is greatly appreciated.
--
LPS