Conditional formatting

[rjc4]

Hi All,

I have a combination of numbers and letters and blank cells in the range A8:A31.

Using conditional formatting can I highlight in say green, the 5 lowest numbers in the range.

Thanks,
RC

 

[venkat1926]

only 24 cells. why not sort and green the 5 lowest

 

[rjc4]

This range is only part of my spreadsheet and as I'm using VLookups elsewhere in the sheet, I'm running into trouble using the sort function. If I can avoid sorting here it would save me further headaches in developing the sheet. Maybe there is no way to do it via conditional formatting. Was just a hope.

Thanks anyway,
Cheers
RC

only 24 cells. why not sort and green the 5 lowest

 

[rjc4]

This range is only part of my spreadsheet and as I'm using VLookups elsewhere in the sheet, I'm running into trouble using the sort function. If I can avoid sorting here it would save me further headaches in developing the sheet. Maybe there is no way to do it via conditional formatting. Was just a hope.

Thanks anyway,
Cheers
RC

only 24 cells. why not sort and green the 5 lowest

 

[Peter_SSs]

rjc4

Try this.

1. Select A8:A31.
2. Format|Conditional Formatting...|Formula Is: =RANK(A8,$A$8:$A$31,1)<=5
3. Click 'Format' and select your colour.
4. OK, OK

 

[rjc4]

Hi Peter,

Exactly what I was after. Thanks heaps for your help.
Kind regards,
Rick

rjc4

Try this.

1. Select A8:A31.
2. Format|Conditional Formatting...|Formula Is: =RANK(A8,$A$8:$A$31,1)<=5
3. Click 'Format' and select your colour.
4. OK, OK