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
|