Conditional Formatting?

[JakeVBA2009]

Hey guys, i've got this spreadsheet here....

http://img260.imageshack.us/img260/2300/vbaj.jpg

As you can tell, its a bit of a shambles and i need some help with figuring out what to do.

I need to display the top "n" and bottom "n" temperatures in the spreadsheet where "n" is a value specified by the user

It needs to be done using four colours as specified by the user aswell with the font colour and background colour for both High Colour and Low Colour.

Thanks, Jake.

 

[lenze]

Say n is in A1
Use CF, Formula Is

=F4>=LARGE(F4:F100,A1 and
=F4<=SMALL(F4:F100,A1)

lenze