Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight lowest value in a list
I would like to highlight the lowest bid in a list of prices submitted by
vendors to stand out. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight lowest value in a list
One way:
Assuming the list is in A1:D1, select the range, and with A1 the active cell choose Format/Conditional Formatting... CF1: Formula is =A1=MIN($A1:$D1) Format1: <pattern/<desired color In article , MRB wrote: I would like to highlight the lowest bid in a list of prices submitted by vendors to stand out. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight lowest value in a list
Let's say vendors names are in A1:A8 and their bids are in B1:B8
Select A1:B8; use Format | Conditional Formatting Select Formula is and enter =$B1=MIN($B$1:$B$8) Now click the Format button on the Conditional Formatting dialog; open the Patterns tab and choose a colour for you highlighting Suppose B5 has the lowest value, then A5:B5 will be highlighted best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MRB" wrote in message ... I would like to highlight the lowest bid in a list of prices submitted by vendors to stand out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CF to highlight lowest price in row | Excel Worksheet Functions | |||
highlight highest and lowest cells within a given column in ex | New Users to Excel | |||
highlight highest and lowest cells within a given column in excel | New Users to Excel | |||
highlight highest and lowest cells within a given column in excel | New Users to Excel | |||
Highlight lowest number | Excel Discussion (Misc queries) |