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

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?