Excel 2007 : Comparing cells to find best results

Sorry...I forgot you to see #'s
just filling in some to get the idea
here ya go

just checking back.....

Is there enough information in the cells to determine my request?

Hi Berk21, IMHO you can choose here to do it using the RANK formula or conditional formatting.
If you are going to use the second. In excel 2007 first select the range where you want to base your top 3. In your book at the sheet "Monthly Review" select from F10 to F34 then go Home -> Conditional formatting -> New Rule... -> Format only top or bottom ranked values -> at the edit the rule description select the appropriate rank or bottom change the 10 for 3 and select the format you want.

If you like use the formula Rank just check the attached book.

Hope you find this helpful.

Thank you pedroxido

Good start..but I was wondering if the top 2 Technicians can be highlighted after the results are ranked as a whole.

I don't want to highlight the 100% and the 99%'s .....I want the formula to compare ALL the techs final scores and find the 2 that excel past the rest, and their name be colored.

maybe this is easier to make sense of this:
pretend the 4 columns are quarters in high school with GPA's...compare all "scores" to get the top 2 in their class.

The last key thing I need is compare all techs in column C10:C34 as long as there is a name in there...not all the time will there only be 17 techs...maybe 20 next month or 5...so the formula has to recognize the all the techs at any given moment.

Thank you in advance....

Here is the actual October spread sheet...with those numbers in place, I need to "rank" my Technicians.....conditional formatting was nice but not all I was looking for...
can I possibly set a numerical value adjacent to the correct person?
ie. Tech A 1st, Tech H 2nd, Tech D 3rd in column J.

Examples in attachment