Highlight lowest number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight lowest price in a row. 6
Highlight the lowest number - only if it does not equal another va 6
highlighting 4
How to highlight the lowest valued cell in a column in Excel 2003 2
Highlight highest / lowest number in a row 3
How to bold lowest value 2
Select low numbers from range + 6
Highlighting the lowest cell automatically 1

Back
Top