Thread: how do I change the font of highest number in a range of cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default how do I change the font of highest number in a range of cells
One play using Conditional Formatting

Assume your range is A1:H1

Select A1:H1 (with A1 active)
Click Format Conditional Formatting
Under Condition 1, use:
Formula is: =A1=MAX($A$1:$H$1)
Click Format button Font tab* Bold & red OK
Click OK at the main dialog
*or go to Patterns tab, select your desired fill color

Test it out ..

Tied max numbers, if any, will be simultaneously conditionally formatted
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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)
Reply With QuoteReply With Quote