Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
determine lowest number in several columns and replace lowest numb | Excel Worksheet Functions | |||
When dragging a number down in Excel, how do we turn off the grow. | Excel Discussion (Misc queries) | |||
how do i find the lowest number in a column in Excel? | Excel Discussion (Misc queries) | |||
Can Excel turn % hrs worked/week put in a cell into a real number | Excel Worksheet Functions | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel |