LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Automatically highlight max and min values in a column in Excel

Is there a way in Excel to automatically highlight the max and min
values in a column? (Without writing any fancy scripts).

I know that there are max/min functions, but being able to highlight
the data point (or perhaps the entire row) instead of seeing the max/
min values in separate cells will make my life much more easier.

Mahurshi Akilla

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to highlight current row & column automatically by a color asif4u Excel Discussion (Misc queries) 8 June 12th 07 04:42 PM
In Excel can I automatically highlight the row im working on? JPAP Excel Discussion (Misc queries) 2 September 29th 06 12:53 PM
Can Excel automatically color highlight entire row of cell I'm in Estephanina Excel Discussion (Misc queries) 3 April 27th 06 09:54 PM
How do I highlight expired dates automatically in excel. adam Excel Discussion (Misc queries) 1 July 31st 05 10:53 PM
how to highlight current row & column automatically by a color iffi Excel Discussion (Misc queries) 1 February 6th 05 06:30 PM


All times are GMT +1. The time now is 07:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"