PC Review


Reply
Thread Tools Rate Thread

COLORING LOWEST FIGURE IN A RANGE

 
 
markstro
Guest
Posts: n/a
 
      19th May 2006
I would like to format the lowest figure in a range to a chosen color.
Can anyone provide a formula or conditional formatting that will do
this. The range will cover about 20 rows.
Thanks

 
Reply With Quote
 
 
 
 
Pete_UK
Guest
Posts: n/a
 
      19th May 2006
Assume data is in column A from A1 to A20. Highlight these cells, then
click Format | Conditional Formatting and in the dialogue box choose
"Formula Is" rather than "Cell Value Is", and in the panel enter this
formula:

MIN($A$1:$A$20)

Click the format button and choose Colour (for foreground) or Patterns
Tab (for background) and pick the colour(s) you wish. Click OK to
return to your sheet, which should now show the chosen colour(s) on the
smallest cell value.

Hope this helps.

Pete

 
Reply With Quote
 
hhenrion
Guest
Posts: n/a
 
      19th May 2006

Hi,

assuming your data is in range A1:A10.

Use conditionql formatting (formula is)
In cell A1 :
=(A1=MIN(A$1:A$10))
an select the format you want for that cell.

NB : if there are several cells with the lowest value, they will all be
highlighted.

Regards,

H.


--
hhenrion
------------------------------------------------------------------------
hhenrion's Profile: http://www.excelforum.com/member.php...o&userid=29626
View this thread: http://www.excelforum.com/showthread...hreadid=543574

 
Reply With Quote
 
markstro
Guest
Posts: n/a
 
      19th May 2006
Thanks, I will try it.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
lowest figure greater than 1 Kendo Microsoft Excel Worksheet Functions 4 28th Oct 2008 06:12 PM
coloring every other row in a range =?Utf-8?B?VGF0?= Microsoft Excel Worksheet Functions 4 11th Jun 2005 07:30 PM
Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc jwebb Microsoft Excel Misc 2 9th Mar 2005 12:38 PM
How can I get the lowest price, second lowest etc. from a range o. =?Utf-8?B?Um9iaW4=?= Microsoft Excel Worksheet Functions 2 9th Nov 2004 12:23 PM
Lowest value in a range =?Utf-8?B?SmFtZXM=?= Microsoft Excel Worksheet Functions 2 24th Oct 2004 08:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:23 PM.