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...