Forum Discussion
Excel Table Editing
You can use conditional formatting to highlight the min or max value in a column.
For example, if your data are in B2:K2000:
Select B2:K2000.
B2 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first dropdown set to 'Cell Value'.
Select 'equal to' from the second dropdown.
Enter =MIN(B$2:B$2000) in the box next to it. Note the use of $ before the first and last row numbers.
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
Repeat these steps, but with the formula =MAX(B$2:B$2000) and a different color.
Thanks for this reply. I had never tried to use the conditional formatting rules, so I gave it a try, but with no luck. It seems if I color the cell that contains that value, I still have to scroll through the data to find the colored cell. That is probably a bit faster to scroll looking for the color, but still not quite what I am looking for. I would like a function that will find a value in a selected column and go directly to that cel without scrolling.
On the formula you wrote, it would appear that the conditional formatting will just find the minimum or maximum and color it. That amounts to using the function cell=min(D23:D2056). Does that not do the same thing without the color or scrolling?
Since you already know the min and max of a column, you could search the column for those values.
Or you can sort the data on a column (ascending or descending); this would bring the min or max of that column to the top.
- OK, I will try the sort approach, thanks.
