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

  • Thread starter Thread starter Mario
  • Start date Start date
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
 
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.
 
Back
Top