Lowest of the low

  • Thread starter Thread starter Voodoodan
  • Start date Start date
V

Voodoodan

Hi,

Out of a range of cells, is there a way to highlight (maybe in
conditional formatting) the three lowest numbers in that range?

Many thanks,
Dan.
 
Hi Voodoodan!

To highlight the lowest number in a range:

Select the range
Format > Conditional Format
Formula Is
=A1=SMALL($A$1:$A$20,1)
Press Format and Select to taste
OK
OK

Amend the formula for additional formats for second and third lowest.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Voodoodan > said:
Hi,

Out of a range of cells, is there a way to highlight (maybe in
conditional formatting) the three lowest numbers in that range?

Many thanks,
Dan.
Click to expand...

Yes. For example, if your range of cells is A1:A50, use conditional
formatting with this formula:
=(OR(A1=SMALL($A$1:$A$50,1),A1=SMALL($A$1:$A$50,2),A1=SMALL($A$1:$A$50,3)))

One limitation is where there are two (or more) cells containing the third
lowest number, when you will see four (or more) cells highlighted.
 
Back
Top