Forum Discussion
Excel - Conditional Formatting Formula Help
Hi, it sounds like you don't necessarily need to the conditional formatting, but rather just want to see if there are discrepancies between the two lists of serial numbers, correct?
In this case, I would just do a basic VLOOKUP between the two lists to see where the discrepancies are, and then apply a conditional format to that column where you look to see if there are any matches. If you post a screenshot of what you are looking to do I can better help you answer the question.
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.