Conditional Formatting for Google Sheets
Budget: ₹600 – ₹1,500 INR
I need a formula written that checks new orders coming in (Sheet 1) against existing inventory (Sheet 2) by comparing 4 columns to find an exact match.
First it needs to find the sku match (J), then if it matches columns M, N, & O on that row it's highlights the row with conditional formatting.
Similar to this:
=AND(J2=INDIRECT("Inventory!J2:J"),M2=INDIRECT("Inventory!M2:M"), C2=INDIRECT("Inventory!N2:N"))
But its not searching all the inventory in the range.
Here is a data set you can see. https://docs.google.com/spreadsheets/d/17FUrE0J1_F6W4XFvX0JqSIqNOy9g1qCb8w32jihP-fI/edit?usp=sharing
First it needs to find the sku match (J), then if it matches columns M, N, & O on that row it's highlights the row with conditional formatting.
Similar to this:
=AND(J2=INDIRECT("Inventory!J2:J"),M2=INDIRECT("Inventory!M2:M"), C2=INDIRECT("Inventory!N2:N"))
But its not searching all the inventory in the range.
Here is a data set you can see. https://docs.google.com/spreadsheets/d/17FUrE0J1_F6W4XFvX0JqSIqNOy9g1qCb8w32jihP-fI/edit?usp=sharing