Excel for Mac 2008 CF

[jfobes]

Need a conditional format to change font of the top 5 numbers in a column.

Any Mac users here?

Thanks

Joe

 

[mikerickson]

I use a Mac. (Excel 2011, I've never used 2008)

I presume that "top 5" doesn't refer to rows 1-5.

Try using Conditional Formatting with the formula =(A1>=LARGE(A:A, 5))

 

[jfobes]

The formula you provided for CF did not work for me.

Perhaps I am entering it wrong. The cells I am trying to work with are B8 - B21 the CF would be to bold, red the numbers in the cells.

I used CF formula is drop down added the formula provided and got nothing.

Changed the formula to =LARGE(B8:B21,5) and it applied the desired format to only 4 of the cells and they were not the four highest numbers, but the first four cells (B8-B11) 85,55,86 and 78
22
STOUGHTON SHOOTERS S T R TOTAL
Aaron 85 91 92 268
Kari 55 44 77 176
Marcus 86 97 99 282
Denis 78 94 90 262
Jack 85 90 88 263
Joe 75 97 91 263
Shawn 71 76 79 226
0
0
0
0
0
0
0
409 469 460 1338

Not sure how to attach the sheet but here are the values I am working with. Once figured out I will be applying this to numerous other columns.

Thank you for your help

 

[T. Valko]

The formula you provided for CF did not work for me.

Perhaps I am entering it wrong. The cells I am trying to work with are B8 - B21 the CF would be to bold, red the numbers in the cells.

I used CF formula is drop down added the formula provided and got nothing.

Changed the formula to =LARGE(B8:B21,5) and it applied the desired format to only 4 of the cells and they were not the four highest numbers, but the first four cells (B8-B11) 85,55,86 and 78
22
STOUGHTON SHOOTERS S T R TOTAL
Aaron 85 91 92 268
Kari 55 44 77 176
Marcus 86 97 99 282
Denis 78 94 90 262
Jack 85 90 88 263
Joe 75 97 91 263
Shawn 71 76 79 226
0
0
0
0
0
0
0
409 469 460 1338

Not sure how to attach the sheet but here are the values I am working with. Once figured out I will be applying this to numerous other columns.

Thank you for your help

I don't know anything about Apple computers/software...

Here's how you would do this on a PC.

Select the entire range of cells in question, B8:B21, starting from cell B8.
In the conditional formatting userform, look for an option something to the effect: "Use a formula to apply this formatting".

The formula would be:

=B8>=LARGE(B$8:B$21,5)

Then select the formats you want to apply.

 

[jfobes]

Perfect!

Thank you very much for your help, I can sleep now!

 

[T. Valko]

Perfect!

Thank you very much for your help, I can sleep now!

You're welcome. Thanks for the feedback!