Range Question
A conditional Formatting solution would include (sample range used)
=B1=MAX($B$1:$B$10)
FWIW,
"millwalll" wrote:
Hi all I have some data that I have sorted then subtotal. Is there way I can
search all cells for the highest number then have the higest number cell
change colour?
Many thanks
I have been trying to think way to do this but not sure what would be best
so want some advice on best option...
|