how do I change the font of highest number in a range of cells
Use Conditional Formats, for example row #10
Select A10 and Format Conditional Formatting... Formula Is
=A10=MAX(10:10)
and pick a nice background color
Then copy this formatting across the entire row.
--
Gary's Student
gsnu200702
"Herman" wrote:
I have 8 columns in a row with #'s in each cell and would like to have the
highest number in that row stand out ie (larger font, or have the cell have
background colour)
|