Largest number in range

R

Richard B. Gardner

I am looking for a formula that will select the largest number in a range
and make that number "bold." Is there a formula that will do this?

Thanks in advance for any help.

RBG
 
D

Dave Peterson

Not a formula (formulas return values--they don't change formatting).

But you could use Format|conditional formatting.

If your range is B3:G9, then select that range and with B3 the activecell, then
click on Format|conditional formatting
Then
Condition 1: Formula is
and use this as the formula: =B3=MAX($B$3:$G$9)

Excel will adjust the formula for all the cells in the selected area.

(Don't forget to change the format to Bold on the font tab of that dialog.)
 
D

Don Guillett

You can use conditional formatting for this
format>conditional formating>formula is
=a1=large($a$1:$a$10,1)
and format for bold and also add a pattern if desired.
Now use your format painter to use the same format for all in rng a1:a10
 
R

Richard B. Gardner

Thank you Dave and Don. However, I'm having a problem with the conditional
formatting. This works just great for columns, but the conditional
formatting, as suggested, does not work on columns. Any ideas?

Thanks Again

RBG
 
R

Richard B. Gardner

Oops, I meant to write that the formatting works on rows, but not on
columns. Thanks.
 
D

Dave Peterson

If you don't get it to work, post back with your range, the active cell address,
and the formula you used.
 
Top