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

M

Mario

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
 
L

Luke M

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.
 
Top