Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
say the 3 bidders cost per item are already on cells B2,B3 and B4
select cells from B2,B3 to B4
format>conditional formatting>formula is
=B2=MIN($B$2:$B$4)
format>font or pattern>choose ur color...

regards,
driller
 
Back
Top