View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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)