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?

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?

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" wrote:

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?

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

Put formula in conditional formating for cell B1. Then copy B1 to entire
Range B1:P30 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.

"Sandeep" wrote:

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" wrote:

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?