View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default Conditional Formating

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