tleonardo1
New Member
- Joined
- Mar 31, 2002
- Messages
- 48
I have a table that has values that I need to compare. The table is as follows:
Warehouse Item Price1 Price2...
So I have the same product in multiple warehouses and I want to make sure the prices match exactly. If they don't I want the rows highlighted. The file has about 10 warehouses and several dozen products and is a couple of thousand lines long.
I tried doing this by having a conditional format that said if cell value does not equal cell value of row above then highlight, hoping that when I autofiltered the list it would reference the cell above it on the FILTERED list, instead it still referenced the cell above it befoire the filter so that did not work. Any ideas on how to handle this?
Thank you.
Tony
Warehouse Item Price1 Price2...
So I have the same product in multiple warehouses and I want to make sure the prices match exactly. If they don't I want the rows highlighted. The file has about 10 warehouses and several dozen products and is a couple of thousand lines long.
I tried doing this by having a conditional format that said if cell value does not equal cell value of row above then highlight, hoping that when I autofiltered the list it would reference the cell above it on the FILTERED list, instead it still referenced the cell above it befoire the filter so that did not work. Any ideas on how to handle this?
Thank you.
Tony