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

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

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