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
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
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
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.
Thanks, works great. I could not remember the Conditional Formatting in
Excel.
Anthony
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks