| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight Highest Amount
I have a bunch of $ figures in column L of my spreadsheet.
How can I highlight in red color the cell in column L that has the highest amount? Thanks. -- tb |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlight Highest Amount
Use CF
Select col L (ie L1 active), then apply CF using Formula Is: =L1=MAX($L:$L) Format to taste, ok out On Thursday, March 1, 2012 10:03:53 AM UTC+8, tb wrote: I have a bunch of $ figures in column L of my spreadsheet. How can I highlight in red color the cell in column L that has the highest amount? Thanks. -- tb |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlight Highest Amount
On 2/29/2012 at 8:18:50 PM Max wrote:
Use CF Select col L (ie L1 active), then apply CF using Formula Is: =L1=MAX($L:$L) Format to taste, ok out Thanks!! -- tb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i highlight the ten highest numbers in a range? | Excel Discussion (Misc queries) | |||
| Highlight Highest number | Excel Programming | |||
| Highlight highest figures | Excel Programming | |||
| Highlight highest numbers in a range. | Excel Programming | |||
| finding highest dollar amount | Excel Worksheet Functions | |||
Linear Mode
