Forum Discussion
Solved
Input 1 to 7 SKU numbers to return groups of rows.
My actual document has 300 cases of product listed in rows, I trimmed it down to 20 cases of product for this example and replaced the names for confidentiality. I want to be able to input these t...
Harun23HR. File attached. Thank you again! I think all I need now is just the border around the SKU sets that are returned, your current formula works. It doesn't need to be a border, it could be different colors for different SKU sets, just something to differentiate them so they don't all blur together.
The annoying thing with ranges & arrays is you have to provision in the Applies To range of the Cond. Formatting rule. In attached file it goes till row 15. Cond. Formula rule is:
=$K2 <> $K3
123456789 ASTMNTS 240CT 9800006356
123456789 ASTMNTS 240CT 9800008635
I guss need above records according to previous MOCKED UP RESULTS BELOW 😊
