compare for high with two or more cells and then flag.
 

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

compare for high with two or more cells and then flag.
 

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