Conditional formatting - highlighting lowest value per row

Hi,

I have made a price comparison table.

It is set out as follows

B = price , C= supplier, code D = price, E = supplier, code F = Price, H = supplier code, J = Price, K, Supplier code, L = Price, M = supplier code, N = price, O = Supplier code.

Each row is a product, so I am trying to compare each suppliers price (B,D,F,H,J,L,N) per row and highlight the cheapest price.

Whenever I get it to work it looks for the cheapest price in the entire table rather than on a row by row basis.

Would really appreciate a nudge in the right direction.

Thanks in advance

Sam

Hi all,

Sorry I didn't get email of a reply!

The product codes vary from the supplier's some are all number some are mixed number and letters etc

Here is an example of my worksheet.

Thanks in advance

Hi,

Thanks for that.

It's worked in some but not in other for some very strange reason.

For example, in one product line a more expensive item is highlighted.

Some rows are empty, and column B has been highlighted in every one, although i'm not to worried about that.

In another there are 3 values £70, £80 and NA and NA has been highlighted dispite this not being apparent in other rows where it is working correctly.

Products in A have no relevance other than me knowing what it is I am looking at.

Thanks for your time, much appreciated.

Any ideas?

Ahh just realised for some reason when I paste it across to my working version it changed the formula to row 5 instead. Seems to be working perfectly now!

That's great thanks, I've tested it and it works perfectly.

Now this may not be possible, but from this data ideally I would like to be able to create another table on a new sheet (same workbook) and to be able to pick out the cheapest prices for each particular item and its associated supplier?

Do you think this is possible or will I need to do this manually?

Thanks again

Hi,

It's probably easier to ignore this column for a minute as I can see if causing problems with this formula.

I'm sorry I can't get the above formula to work, its coming up with a #REF error.

Hi,

That works for the part number and price thanks!

Any way to get the suppliers name in there somehow as well?

Thanks again, really appreciate your help.

Sorry, missed that.

they are B1,D1,F1,H1,J1,L1,N1

Basically the idea with column N was to have the suppliers name in the part number column so that it could be universal for suppliers who I only source a few products from, but I will be changing this.

Thanks agian

That's worked perfectly thanks!

Just 1 thing, sorry. In rows where they are blank I get a #NA error, can this be blank if there is no data?

Thanks again

That's perfect, thanks very much for all your help!