D
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?
stand out and also so it will remain on the worksheet?
J
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)
formula in F1 then copy and PasteSpecial using Format option
=F1=MAX(F$1:F$10)
S
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.
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.
J
Joel
=B1=MAX($B$1:$P$30)
Put formula in conditional formating for cell B1. Then copy B1 to entire
Range B1
30 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.
Put formula in conditional formating for cell B1. Then copy B1 to entire
Range B1
30 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.