I need help setting up conditional formatting in an Excel Spreadsheet. I am
getting ready to review numbers from several vendors regarding office
supplies. After inputting the cost per item from each vendor (I have 3
bidders) I would like Excel to identify the lowest price of the three and
highlight that cell in a predetermined color. Is there a way to set this up?

Your help is appreciated.
--
Beomeister

say the 3 bidders cost per item are already on cells B2,B3 and B4
select cells from B2,B3 to B4
formatconditional formattingformula is
=B2=MIN($B$2:$B$4)
formatfont or patternchoose ur color...

regards,
driller
--
*****
birds of the same feather flock together..



"Beomeister" wrote:

I need help setting up conditional formatting in an Excel Spreadsheet. I am
getting ready to review numbers from several vendors regarding office
supplies. After inputting the cost per item from each vendor (I have 3
bidders) I would like Excel to identify the lowest price of the three and
highlight that cell in a predetermined color. Is there a way to set this up?

Your help is appreciated.
--
Beomeister

Format/ Conditional Formatting/ Cell value is/ equal to:
=MIN($A1:$C1)
--
David Biddulph

"Beomeister" wrote in message
...
I need help setting up conditional formatting in an Excel Spreadsheet. I
am
getting ready to review numbers from several vendors regarding office
supplies. After inputting the cost per item from each vendor (I have 3
bidders) I would like Excel to identify the lowest price of the three and
highlight that cell in a predetermined color. Is there a way to set this
up?

Your help is appreciated.
--
Beomeister