Conditional Formatting
 

How do I highlight any cell in , say, A1:M1 that is equal to the maximum
value in that range.


Thanks
Bertrand

Conditional Formatting
 

Hi Bertrand,

Select Cell A1:M1

Click Format Conditional Formatting and enter this forumla

=A1AVERAGE($A$1:$M$1)

or

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563962

Conditional Formatting
 

Select A1:M1

FormatCFFormula is

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


Gord Dibben MS Excel MVP

On Sat, 22 Jul 2006 12:41:12 +0200, "Bertrand" wrote:

How do I highlight any cell in , say, A1:M1 that is equal to the maximum
value in that range.


Thanks
Bertrand