APPLYING SAME CONDITION TO FORMAT SEVERAL ROWS

B

BOYWONDER1997

I am working on the sheet that has 4 columns and multiple rows. Each row is a
generic record for each product company buys. The first column in each row is
product description, the next 3 columns are prices offered by 3 different
vendors for that particular product. I want to format my sheet in such a way
that for every product, the least price gets highlighted, and if possible the
second least price gets highlighted too (with a different color). Appreciate
your help in this regard.
 
B

Bob Umlas, Excel MVP

Select all the cells B1:D100 (or whatever)
use format/conditional formatting
change "cell value is" to "formula is"
enter =$B1=MIN($B1:$D1) and click the format button & choose a font or
color, click OK
then Click Add, enter
=$B1=SMALL($B1:$D1,2) and repeat the process for your 2nd lowest #.
 
F

Frank Kabel

Hi
try the following
- select cells B2:D2
- goto Format - Conditional Format
- enter the following formula
=B2=MIN($B2:$D2)
- choose a format

For the second least price use
=B2=SMALL($B2:$D2,2)
 
Top