View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Minimum highlight

Hi Timothy,

Use conditional formating to highlight it, chose "the formula is" and put:

=B2=$d$1

Assuming that you have the minimmum formula on the D1 cell;

regards from Brazil

Marcelo



"Timothy Langaster" escreveu:

Ive a table with prices:
A B C D
Apples 1.50 1.75 =MIN($B2:$C2)
Bananas 2.20 2.19

I use the formula minimum to find the cheaper price but I need also to
highlight the cheaper price on column B or C. Any idea please?