| 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 |
| 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 | |||
Threaded Mode
