Challenge!! Need help though. (Conditional formatting)

knuckles70 · #1 02-03-2010, 12:48 PM

Hello.
On microsoft office excel 2007, how can I create a formula for this...

I have conditionally formatted a group of cells. The highest value of those cells is highlighted. Each value of the cell represents a persons score. How do I get the person with the highest scores name into a seperate box? Please help!!!

ConneXionLost · #2 02-03-2010, 05:03 PM

Assuming your range of grades is A1:A5, select the range and add this formula to the Conditional Formatting:

Code:

=A1=MAX($A$1:$A$5)

Adjust your range and reference to the top left cell as necessary.

Cheers,

FraserKitchell · #3 02-05-2010, 12:24 PM

Assuming the person's name is located next to the score (in column B), and the list is A1:A5 as above, you'll need to use a vlookup. First get the max score in a cell (formula : =max(A1:A5); put this cell in C1

Then use a vlookup, (formula : =vlookup(C1, A1:B5, 2, False)

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Urgent help regarding automation.	aligahk06	Excel	1	01-14-2010 01:55 PM
Urgent Help Required	id12345	Word	4	12-29-2009 08:22 AM
Weird but urgent identity problem	Afterburn	Outlook	0	12-10-2009 01:30 AM
kindly fix my problem its urgent!	SyedaAdil	Office	1	11-04-2009 08:15 AM
Urgent help!	captainspi	Word	2	04-19-2009 11:17 AM