Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default highlight highest and lowest cells within a given column in excel

Not a formula, per se, you have to use the feature called Conditional
Formatting.
Highlight the column/area you wish to format, then do Format Conditional
Formatting
then in the pop-up window, for condition 1, set "Cell Value Is" "equal to"
=MAX($A:$A), then click FORMAT and set the desired formatting.

Then click ADD, and for condition 2 set "Cell Value Is" "equal to"
=MIN($A:$A), then click FORMAT and set the desired formatting for that
condition. then click OK and you're done.......however, if you have two or
more cells that equal the MAXIMUM or MINIMUM value they will all be
highlighted.

hth
Vaya con Dios,
Chuck, CABGx3



"Tim" wrote:

Is there a formula to highlight (in a different colour) a only the highest
and the lowest number in one column.
I am not sure if this possible to do in excel 2003.

Reply
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
highlight highest and lowest cells within a given column in ex Tim New Users to Excel 0 November 29th 06 11:36 PM
Highest & lowest place value / decimal places of cell value Neil Goldwasser Excel Worksheet Functions 2 March 15th 06 03:27 PM
Rank where lowest value is highest rank mile3024 Excel Worksheet Functions 2 December 9th 05 11:57 PM
How do i sort a group of cells from highest to lowest JulieR Excel Discussion (Misc queries) 2 March 8th 05 09:31 PM
How to find highest, lowest and last cell in a row? Sam Excel Worksheet Functions 1 December 3rd 04 12:51 PM


All times are GMT +1. The time now is 10:35 PM.

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

About Us

"It's about Microsoft Excel"