Determining the highest number in a row
 

Hello Excel(lent) users,

I have a problem I would like to discuss with you.

Kelly, Hank and George are selling different kinds of stuff. Apples, pears,
plums etc etc. Each item they sell will be noted and in a pivot table it will
be presented. Now I want to know who is the best apple seller, the best pear
seller etc etc.. i.e.
In a row of numbers I want to determine which is the highest and then
highlight it.

For instance:
Kelly Hank
George Total
Apples 2 7
12 21
Pears 1 6
1 8
Plums 4 5
0 9

From the above list you can immediately see that george is the best apple
seller, Hank the best Pear seller and kelly the best plum seller.

This example is simplified, but when you are talking about 40 sellable items
and 10 sellers, it will be impossible to see who is the best seller per item.
That is why I want to highlight the highest number per item.....

Can you please help me ??

Kind regards,

Jaydubs


--
** Fool on the hill **

Determining the highest number in a row
 

Highlight B2:E4 and select Format-Conditional Formating. Select "Formula
Is" and input this formula
=MAX($B2:$E2)=B2
include both equal signs.

"Jaydubs" wrote:

Hello Excel(lent) users,

I have a problem I would like to discuss with you.

Kelly, Hank and George are selling different kinds of stuff. Apples, pears,
plums etc etc. Each item they sell will be noted and in a pivot table it will
be presented. Now I want to know who is the best apple seller, the best pear
seller etc etc.. i.e.
In a row of numbers I want to determine which is the highest and then
highlight it.

For instance:
Kelly Hank
George Total
Apples 2 7
12 21
Pears 1 6
1 8
Plums 4 5
0 9

From the above list you can immediately see that george is the best apple
seller, Hank the best Pear seller and kelly the best plum seller.

This example is simplified, but when you are talking about 40 sellable items
and 10 sellers, it will be impossible to see who is the best seller per item.
That is why I want to highlight the highest number per item.....

Can you please help me ??

Kind regards,

Jaydubs


--
** Fool on the hill **