Comparing individual rows across columns

[marciokoko]

I have a market study of different suppliers who quoted me 10 different SKUs. So i have SKUs in the rows and each column is a different supplier:

Screenshot 2019-09-30 11.12.02.png

So I need to compare each item (in rows) across the different suppliers, to pick the lowest value as shown in yellow.

How would I build that rule in Conditional Formatting?

Thanks

[63falcondude]

Hello and welcome to the forum.

It's difficult to offer a solution based off of a picture instead of an Excel workbook (which you can upload here).

That being said, assuming your data to be conditionally formatted is in columns D, F, and H starting in row 4, try this:

Highlight D4:H100 (or however far your data goes) > Conditional Formatting > New Rule > Use a formula
=AND(MIN($D4,$F4,$H4)=D4,D$3="Unit Price")
Format: Fill yellow > OK > OK

[marciokoko]

Ok I tried your formula but couldnt get it to work. Sorry about the attachment, here it is.

[FlameRetired]

Please try this formula instead. I do not know if your version of Excel has the AGGREGATE function or not. I didn't text anything else so there may be another solution out there.

Please Login or Register  to view this content.