Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
Conditional Format to highlight entrire Row | Excel Worksheet Functions | |||
How can I highlight every other group of data? | Excel Discussion (Misc queries) | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
Sum minimum values in a pivot table | Excel Worksheet Functions |