Forum Discussion
Excel - Conditional Formatting Formula Help
Hello all! I'm trying to analyze two pivot tables and I would like to create a conditional formatting formula that will highlight matches and discrepancies. The values I want to compare are on se...
I want to find the matches and discrepancies of QTY and Amount for each individual part number. It looks something like this:
Hi, these don't look like pivot tables, just regular tables in Excel. They are different datasets right? I would put a VLOOKUP() formula in column D to compare if the IDs in column A are found in the two other tables to the right of the 1st table, make sense?
The ID's in column A are all in the other two tables, I want to analyze their respective quantities and price are the same, does that make sense?
I see. Yes in column D I would do a VLOOKUP to pull in the quantities and amounts from the other two tables, and set up another column to compare the numbers with the 1st table.