Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Amber M
 
Posts: n/a
Default Highlight lowest number

Can you select a range and have the lowest number automatically be
highlighted in red?
thanks!
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

1. Select the range and name it "myrange" (no quotes).
Press Ctrl+F3 or go to Insert Name Define.
2. Go to Format Conditional Formatting.
3. Select "Formula Is" and put:
=INDIRECT("rc",0)=MIN(myrange)
4. Press the "Format" radio button and format as desired.

HTH
Jason
Atlanta, GA

-----Original Message-----
Can you select a range and have the lowest number

automatically be
highlighted in red?
thanks!
.

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Why not just use the address directly for the activecell?

Select the range (say B12:F92) and with B12 the activecell:
format|conditional formatting
formula is:
=b12=min($b$12:$f$92)

(using the range name would still work and may be easier to decipher later.)



Jason Morin wrote:

1. Select the range and name it "myrange" (no quotes).
Press Ctrl+F3 or go to Insert Name Define.
2. Go to Format Conditional Formatting.
3. Select "Formula Is" and put:
=INDIRECT("rc",0)=MIN(myrange)
4. Press the "Format" radio button and format as desired.

HTH
Jason
Atlanta, GA

-----Original Message-----
Can you select a range and have the lowest number

automatically be
highlighted in red?
thanks!
.


--

Dave Peterson
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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Number of Column Limitations kbarrios Excel Discussion (Misc queries) 2 January 6th 05 04:12 PM
Adding + in front of a number Ted Metro Excel Discussion (Misc queries) 3 December 29th 04 11:45 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM


All times are GMT +1. The time now is 11:03 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"