Use conditional formating with this formula if the data is in Column F. Put
formula in F1 then copy and PasteSpecial using Format option

=F1=MAX(F$1:F$10)

"deegee" wrote:

How do I assign a color to the highest value in a "Total" column so it will
stand out and also so it will remain on the worksheet?