Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lowest number with a colr
Hello everyone
How can I color a cell that is the lowest #. I had a formula but even cells both get colored. I need strictly the lowest. Example column A, B & C each has 200 rows I need strictly the cell with the lowest figure colored. -- smile |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lowest number with a colr
Select A1 through C200 starting with A1... the easiest way to do this is to
type A1:C200 in the Name Box (the type-in drop-down field at the left side of the Formula Bar). Next, click on Format/Conditional Formatting on Excel's menu bar. On the dialog box that appears, select Formula is from the first drop-down and put this formula in the second (blank) field... =A1=MIN($A$1:$C$200) On the next dialog box that appears, click the Format button and then select the Patterns tab, select a color you want the cell to be colored with, and then OK your way back to the worksheet. The cell (or cells) with the lowest value in it (them) will show that color. -- Rick (MVP - Excel) "israel" wrote in message ... Hello everyone How can I color a cell that is the lowest #. I had a formula but even cells both get colored. I need strictly the lowest. Example column A, B & C each has 200 rows I need strictly the cell with the lowest figure colored. -- smile |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
determine lowest number in several columns and replace lowest numb | Excel Worksheet Functions | |||
Lowest number above 0 | Excel Discussion (Misc queries) | |||
Lowest number | Excel Worksheet Functions | |||
lowest number above 0 | Excel Discussion (Misc queries) | |||
how to subtract the very next LOWEST number | New Users to Excel |