Thread
:
Minimum highlight
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Timothy Langaster
Posts: n/a
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?
Reply With Quote