Highlight lowest number
 

Can you select a range and have the lowest number automatically be
highlighted in red?
thanks!

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!
.

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