View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Conditionally formatting highest valued cell?

Hi!

Assume the range of cells in question is A1:A7.

Select the range A1:A7
Goto FormatConditional Formatting
Formula is: =A1=MAX(A$1:A$7)
Click the Format button
Select the Font tab
In the Color drop down select your choice
OK out

Biff

"brett" wrote in message
oups.com...
I have 7 rows in the same column of type percentage. I'd like to turn
the text of the highest valued cell red. How exactly is that done with
contional formatting (vs. IF statements for each cell)?

Thanks,
Brett