Challenge!! Need help though. (Conditional formatting)

		Microsoft Office Forums > Microsoft Excel > Excel
Challenge!! Need help though. (Conditional formatting)

FAQ

Thread Tools

Display Modes

02-05-2010, 12:24 PM

FraserKitchell FraserKitchell is offline

Windows XP Challenge!! Need help though. (Conditional formatting)

Office 2007

Novice

Join Date: Dec 2009

Posts: 21

FraserKitchell is on a distinguished road

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

Tags

conditional format

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 PM.