Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Conditiona l Formatting to flag cells with a date in the pas | Excel Discussion (Misc queries) | |||
Excel 2007: Color of high-lighted cells | Excel Discussion (Misc queries) | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Can Excel automatically flag up cells within given values? | Excel Discussion (Misc queries) | |||
flag cells | New Users to Excel |