Largest number in range

  • Thread starter Thread starter Richard B. Gardner
  • Start date Start date
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
 
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.)
 
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
 
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
 
Oops, I meant to write that the formatting works on rows, but not on
columns. Thanks.
 
If you don't get it to work, post back with your range, the active cell address,
and the formula you used.
 
Back
Top