FINDING MAX VALUES IN SELECTED ROW

[tdieren]

I'M LOOKING FOR A WAY TO HIGHLIGHT,BOLD, OR FORMAT A VALUE THAT IS THE LARGEST OF A SELECTED GROUP OF CELLS.

EXAMPLE: I HAVE VALUES ENTERED IN ROW 19 COLLUMNS C THRU N.
I WANT TO MAKE THE LARGEST NUMBER BOLD.

I HAVE TRIED USING CONDITIONAL FORMATIING - ENTERING =A2=MAX(2:2)

WHAT IS A2 REFFERING TO? CELL A2? HOW ABOUT (2:2) BOLD?

 

[Aladin Akyurek]

On 2002-10-16 14:57, tdieren wrote:
I'M LOOKING FOR A WAY TO HIGHLIGHT,BOLD, OR FORMAT A VALUE THAT IS THE LARGEST OF A SELECTED GROUP OF CELLS.

EXAMPLE: I HAVE VALUES ENTERED IN ROW 19 COLLUMNS C THRU N.
I WANT TO MAKE THE LARGEST NUMBER BOLD.

I HAVE TRIED USING CONDITIONAL FORMATIING - ENTERING =A2=MAX(2:2)

WHAT IS A2 REFFERING TO? CELL A2? HOW ABOUT (2:2) BOLD?

The formula that you need to use should be:

=C19=MAX($C$19:$N$19)

 

[Mark W.]

SEE YOUR PREVIOUS POSTING...

http://216.92.17.166/board/viewtopic.php?topic=25562&forum=2

 

[tdieren]

On 2002-10-16 15:00, Aladin Akyurek wrote:

On 2002-10-16 14:57, tdieren wrote:
I'M LOOKING FOR A WAY TO HIGHLIGHT,BOLD, OR FORMAT A VALUE THAT IS THE LARGEST OF A SELECTED GROUP OF CELLS.

EXAMPLE: I HAVE VALUES ENTERED IN ROW 19 COLLUMNS C THRU N.
I WANT TO MAKE THE LARGEST NUMBER BOLD.

I HAVE TRIED USING CONDITIONAL FORMATIING - ENTERING =A2=MAX(2:2)

WHAT IS A2 REFFERING TO? CELL A2? HOW ABOUT (2:2) BOLD?

The formula that you need to use should be:

=C19=MAX($C$19:$N$19)

Thanks for the help.

 

[Mark W.]

You're welcome.