Conditional formatting

rjc4

Well-known Member
Joined
Nov 6, 2004
Messages
502
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
 

rjc4

Well-known Member
Joined
Nov 6, 2004
Messages
502
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


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

rjc4

Well-known Member
Joined
Nov 6, 2004
Messages
502
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


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

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,756
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Nov 6, 2004
Messages
502
Hi Peter,

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


Peter_SSs said:
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
 

Forum statistics

Threads
1,078,006
Messages
5,337,693
Members
399,162
Latest member
Sabina

Some videos you may like

This Week's Hot Topics

Top