Let's assume you want to find the lowest three numbers in column A, starting
in A1, and you are using XL2007. In the future, if you want more specific
instructions, provide sufficient information so we don't have to make
assumptions.

Select A1.
Click Conditional FormattingNew Rule...Use a formula to determine which
cells to format
In the box Format values where this formula is true, enter:
=a1=small(a:a,1)
Click Format...Fill, choose a color, click OK.
Do this again for the second smallest, using the formula:
=a1=small(a:a,2), and choose a different color.
For the third smallest, use:
=a1=small(a:a,3), and its color.

Now copy this formatting to the rest of the cells in your range. The easiest
way to do this is to right-drag the fill handle down the column. When you
release the mouse button, choose Fill Formatting Only.

Regards,
Fred


"frankjh19701" wrote in message
...

'Fred Smith[_4_ Wrote:
;930040']Use conditional formatting, and a formula like:
=a1=small(a:a,1)

Regards,
Fred



"frankjh19701" wrote in message

...-

I need a formula that will find the lowest three values in a given
row
or column. I would like to be able to highlight them in different
colors.

Any/all assistance is greatly appreciated.

Thank you




--
frankjh19701 -

Thank you for responding
Ummm, O.K. how would I accomplish this with multiple cells from around
the spreadsheet?
I think I need a little bit more help.




--
frankjh19701