Have 3 columns, L M N which display percentage results based on values
entered in other columns (cells in columns contain count formulas)
In these columns I want the max result to highlight in different color

I tried
cell value is - equal to - =max(L4:L20)
but does nothing

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value

maybe...

equal to:
=max($l$4:$l$20)

or
formula is:
=L4=max($L$4:$L$20)
(with L4 the active cell)

Nadine wrote:

Have 3 columns, L M N which display percentage results based on values
entered in other columns (cells in columns contain count formulas)
In these columns I want the max result to highlight in different color

I tried
cell value is - equal to - =max(L4:L20)
but does nothing

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value

--

Dave Peterson

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value

Use the above but change the formula to:

=L4=max($L$4:$L$20)


--
Biff
Microsoft Excel MVP


"Nadine" wrote in message
...
Have 3 columns, L M N which display percentage results based on values
entered in other columns (cells in columns contain count formulas)
In these columns I want the max result to highlight in different color

I tried
cell value is - equal to - =max(L4:L20)
but does nothing

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value

neither worked.

first one, changed nothing

second one, only changed L4 to red and that one wasn't the max number


"T. Valko" wrote:

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value

Use the above but change the formula to:

=L4=max($L$4:$L$20)


--
Biff
Microsoft Excel MVP


"Nadine" wrote in message
...
Have 3 columns, L M N which display percentage results based on values
entered in other columns (cells in columns contain count formulas)
In these columns I want the max result to highlight in different color

I tried
cell value is - equal to - =max(L4:L20)
but does nothing

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value

Do you have all the $ signs in the correct place?

You want a fixed range but a relative cell............L4


Gord Dibben MS Excel MVP

On Wed, 9 Jul 2008 20:11:01 -0700, Nadine
wrote:

neither worked.

first one, changed nothing

second one, only changed L4 to red and that one wasn't the max number


"T. Valko" wrote:

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value

Use the above but change the formula to:

=L4=max($L$4:$L$20)


--
Biff
Microsoft Excel MVP


"Nadine" wrote in message
...
Have 3 columns, L M N which display percentage results based on values
entered in other columns (cells in columns contain count formulas)
In these columns I want the max result to highlight in different color

I tried
cell value is - equal to - =max(L4:L20)
but does nothing

I tried
formula is =L4=max(L4:L20)
changes everything to red except for the lowest value