View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Conditional formatting of a column of values

One way:

Select the column, say, column A, with the cell in row 1 (e.g., A1)
active. Choose Format/Conditional Formatting...

CF1: Formula is =A1=MAX(A:A)


In article ,
Joe wrote:

I'm looking to c.f. a column of values that show the highest value based on
the other values in that column.