Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change cell color if it is the lowest number of a group?
I was wondering how do you change the color of the number in a cell when that
number is the lowest number in a group of cells? Thanks in advance. Anthony |
#2
|
|||
|
|||
Change cell color if it is the lowest number of a group?
I used this formula in "Conditional Formatting" in cell B3:
=B3=MIN($B$3:$B$6) .... and applied a distinctive cell format. Then I copied cell B3 and pasted it into B4 to B6. Enter a series of numbers into B3 to B6 and the lowest number shows the format you applied. |
#3
|
|||
|
|||
Change cell color if it is the lowest number of a group?
Hi, Use conditional formatting and the MIN formula using these settings Cell Value is: Equal to: and type your formula e.g... =MIN($A$1:$B$10) choose your format and hit OK. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=477734 |
#4
|
|||
|
|||
Change cell color if it is the lowest number of a group?
Thanks, works great. I could not remember the Conditional Formatting in
Excel. Anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First Number in a Cell | Excel Worksheet Functions | |||
how change number in cell to text | Excel Discussion (Misc queries) | |||
Histograms: how change number of bins | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
multiply by actual number in cell | Excel Worksheet Functions |