Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XL2000, CF and List Comparisons
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. -- LPS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XL2000, CF and List Comparisons
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 On Sep 29, 6:54*pm, LPS wrote: 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. -- LPS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XL2000, CF and List Comparisons
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. -- Thanks, Shane Devenshire "LPS" wrote: 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. -- LPS |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XL2000, CF and List Comparisons
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, -- LPS "Pete_UK" wrote: 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 On Sep 29, 6:54 pm, LPS wrote: 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. -- LPS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2000 CF and Comparing Lists | Excel Worksheet Functions | |||
XL2000 - Average/If/And Functions | Excel Worksheet Functions | |||
XL2000 More Function Problems | Excel Worksheet Functions | |||
Workday function in XL2000 | Excel Worksheet Functions | |||
FORMULAS IN CHARTS? xl2000 | Charts and Charting in Excel |