Quick formula for you experts

[jfobes]

I am looking for a formula to bold, highlight or change font color of the five highest values in a column then add those together for a total value of the five highest numbers in that column.

I am using excel for Mac 2008 if this helps or hurts?

Possible?

Thanks

Joe

 

[mikerickson]

The bolding can be done with Conditional Formatting.

The formula =SUMPRODUCT(LARGE(A:A, {1,2,3,4,5}) will do the sum.

 

[jfobes]

That worked perfectly, thank you. I have some experience with conditional formatting but not on how to change the font of the top five numbers in a row or column.

Any more help?

Joe

 

[T. Valko]

I am looking for a formula to bold, highlight or change font color of the five highest values in a column then add those together for a total value of the five highest numbers in that column.

I am using excel for Mac 2008 if this helps or hurts?

Possible?

Thanks

Joe

This will get the sum of the 5 largest values...

=SUM(LARGE(C:C,{1,2,3,4,5}))

You can use conditional formatting to highlight those cells but I have no idea how to do that in Excel for Mac!

 

[mikerickson]

...You can use conditional formatting to highlight those cells but I have no idea how to do that in Excel for Mac!

Pretty much the same way as with Windows. The CF formula
=(LARGE(A:A,5)<=A1)
should work.

 

[T. Valko]

Pretty much the same way as with Windows. The CF formula
=(LARGE(A:A,5)<=A1)
should work.

Yeah, but what I meant was, is Excel for Mac 2008 the equivalent of Excel 2007 for PCs (ribbon?) or does it have a "classic" menu UI?

 

[mikerickson]

In 2011, when I press ConditionalFormatting and add a condition (press +), one of the dropdowns on the resulting dialog box has Classic as an option.