Hi Guys;
I have this sheet, Mario's and Joe picks, i need to flag who has the highest
percentage number in colummn D5 or D11. In these example D5 is higher than
D11, can i set the cell in Red or put a message in the next cell (E5 ). I may
add more guys into my sheet.
Tks in advance, i'm new in Excel.
Mario

A B C D E
1 MARIO
2 GOOG 200 0.20
3 FDX 50 0.05
4 IBM 100 1.20
5 350 3.45 <== Best
6
7 JOE
8 MSFT 25 0.10
9 DELL 45 -.50
10 ORCL 20 1.00
11 90 0.60

Select cell D5 and D11 at the same time (hold Ctrl to select discontinuous
cells). With cell D5 being the active cell, conditional format, formula is:

=D5=MAX($D$5,$D$11)
Set a format of red backgroun.

Ok out.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mario" wrote:

> Hi Guys;
> I have this sheet, Mario's and Joe picks, i need to flag who has the highest
> percentage number in colummn D5 or D11. In these example D5 is higher than
> D11, can i set the cell in Red or put a message in the next cell (E5 ). I may
> add more guys into my sheet.
> Tks in advance, i'm new in Excel.
> Mario
>
> A B C D E
> 1 MARIO
> 2 GOOG 200 0.20
> 3 FDX 50 0.05
> 4 IBM 100 1.20
> 5 350 3.45 <== Best
> 6
> 7 JOE
> 8 MSFT 25 0.10
> 9 DELL 45 -.50
> 10 ORCL 20 1.00
> 11 90 0.60
>