Auto formatting

[deegee]

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?

 

[Joel]

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)

 

[Sandeep]

Joel,
Pls expand this question as 'How do I assign a color to the highest value in
a cell whoose range is say B1 to P30 columns say from B to P (15 columns) &
Rows chosen from 1 to 30.

 

[Joel]

=B1=MAX($B$1:$P$30)

Put formula in conditional formating for cell B1. Then copy B1 to entire
Range B130 and Paste using PasteSpecial choosing "Format" option.

I put the $ infront of the column letter because you are using more than
one column. With only one column the $ was not necessary.