Forum Discussion
Excel Table Editing
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.