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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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