Conditional formatting
 

I need to format various columns of data so that the highest value in the
column shows as bold (ie; cells A1:A300 - A57 is bold as it has the highest
value).

I am trying to do this in conditional formatting by selecting the range (ie;
A1:A300) so that A1 is the active cell and then:

Formula Is
=MAX(A1:A300)

But all of the cells are shown as highlighted!

What am I doing wrong?

Thanks.

Conditional formatting
 

Select your range and try a conditional format of 'Formula is" and set to bold

=A1=MAX($A$1:$A$300)

Mike

"Terry Bennett" wrote:

I need to format various columns of data so that the highest value in the
column shows as bold (ie; cells A1:A300 - A57 is bold as it has the highest
value).

I am trying to do this in conditional formatting by selecting the range (ie;
A1:A300) so that A1 is the active cell and then:

Formula Is
=MAX(A1:A300)

But all of the cells are shown as highlighted!

What am I doing wrong?

Thanks.

Conditional formatting
 

Mike. That seems to have cured it - many thanks.

Must admit I wouldn't have stumbled on the '=A1=MAX' syntax!!

"Mike H" wrote in message
...
Select your range and try a conditional format of 'Formula is" and set to
bold

=A1=MAX($A$1:$A$300)

Mike

"Terry Bennett" wrote:

I need to format various columns of data so that the highest value in the
column shows as bold (ie; cells A1:A300 - A57 is bold as it has the
highest
value).

I am trying to do this in conditional formatting by selecting the range
(ie;
A1:A300) so that A1 is the active cell and then:

Formula Is
=MAX(A1:A300)

But all of the cells are shown as highlighted!

What am I doing wrong?

Thanks.