Formula Code Help

[Guest]

Hi

I'm working on a spreadsheet that contrasts the pricing of different products from different suppliers, as follows

Supplier A Supplier B Supplier
Product X $50 $40 $3
Product Y $30 $40 $5

Etc. What i have been trying to do through conditional formatting is to highlight the cell with the lowest price for each product. However, I dont know how to write the formula so that I can fill down for each row, because conditional formatting only allows me to refer to each specific cell, thus I have to do the same conditional format 80 times for 80 different rows. I just need to know the syntax for the code to write the formula. Thanks

Tob

 

[JE McGimpsey]

conditional formatting only allows me to refer to each specific cell

Well, no.

Select B2x, with B2, C2, or D2 the active cell

Choose Format/Conditional Formatting... and enter

CF1: =AND(B2=MIN($B2:$D2), COUNT($B2:$D2)>0)
Format1: <highlight as desired>

using the relative and mixed addresses will cause XL to correctly update
the cell references

 

[JE McGimpsey]

Note that I assumed B2 was the active cell in CF1.