LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 42
Default How do I get the lowest number in a row to turn red in Excel ?

If you had your numbers in Column A from rows 1 to 8, like below:

A
1 1
2 5
3 4
4 2
5 6
6 7
7 8
8 0.5

Select those cells, starting from A1 (click and drag to A8, or holding down
the Shift key, use the arrow keys or click A8 with the mouse) and go to the
menu "Format" then "Conditional Formatting." For Condition 1, choose
"Formula Is" from the first drop-down menu, then type in "=MIN($A$1:$A$8)=A1"
without the quotes (make sure to keep the dollar signs so the range won't
change as the formula is evaluated at each cell, also make sure that after
the second equal sign you don't have a dollar sign so that the cell address
will change). Then press the "Format" button and choose the "Patterns" tab,
and whatever color you wish. Press "OK" and then again. In the example
above, the 0.5 cell should highlight to whatever color you choose in the
"Patterns" tab.

To modify this for your file, just change the range from $A$1:$A$8 to
whatever top-left to bottom-right cells you are interested in. And change
the A1 to whatever cell is selected as you go into the Conditional Formatting
screen.

Hope this helps, Jim
--
I appreciate any feedback. Please don''t be scared to say that "Yes,"
I/someone else did answer your question. Thank you.
 
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
determine lowest number in several columns and replace lowest numb jerry Excel Worksheet Functions 1 June 18th 08 03:19 AM
When dragging a number down in Excel, how do we turn off the grow. Carl Excel Discussion (Misc queries) 2 November 4th 05 07:55 AM
how do i find the lowest number in a column in Excel? MKA808 Excel Discussion (Misc queries) 4 August 23rd 05 07:27 PM
Can Excel turn % hrs worked/week put in a cell into a real number BaffledFloridaExcelUser Excel Worksheet Functions 1 August 2nd 05 11:21 PM
Excel - turn a page number in a header from horizontal to vertical pbrookstx Charts and Charting in Excel 1 June 4th 05 01:01 AM


All times are GMT +1. The time now is 07:50 AM.

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

About Us

"It's about Microsoft Excel"