Lowest price.

  • Thread starter Thread starter Gabriela Martins
  • Start date Start date
G

Gabriela Martins

Hi,
How do I calculate lowest price and how I add red colour in this formula.
Thanks for any responses.
Gabriela Martins
 
Calculate

=MIN($A$2:$A$100)

to add red colour, select A2:A100 with A2 as the active cell,
do format>conditional formatting> formula is and use



=A2=MIN($A$2:$A$100)

click the format button, patterns, select red or fonts select red,
click OK twice

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top