Max Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

phuser - 27 Feb 2008 14:47 GMT

I am trying to use Conditional Formatting to find the Max value in a Row
using =Max(B6:AC6), having that cell Highlight to a different color but the
=Max is highlighting them all.

Help

Reply to this Message

Chris J Dixon - 27 Feb 2008 14:57 GMT

>I am trying to use Conditional Formatting to find the Max value in a Row
>using =Max(B6:AC6), having that cell Highlight to a different color but the
>=Max is highlighting them all.

There may be other ways, but what I do is create a column, or in
your case cell, (can be hidden, or way out of sight) having the
formula =Max(B6:AC6). Then use the value of that cell as the
comparison for your conditional format.

Chris

Signature

Chris J Dixon Nottingham UK
chris@cdixon.me.uk

Have dancing shoes, will ceilidh.

Reply to this Message

Pete_UK - 27 Feb 2008 15:01 GMT

Highlight all the cells you want this to happen to (B6:AC6 ?) with B6
as the active cell in the range, then click on Format | Conditional
Formatting and choose Formula Is rather than Cell Value Is in the
first box of the pop-up. In the second box enter this formula:

=B6=MAX($B6:$AC6)

then click on the Format button, select the Patterns tab (for
background colour) and click on the colour you want to use for the
highlight. Then click on OK twice to exit the CF dialogue box.

Hope this helps.

Pete

> I am trying to use Conditional Formatting to find the Max value in a Row
> using =Max(B6:AC6), having that cell Highlight to a different color but the
> =Max is highlighting them all.
>
> Help

Reply to this Message

phuser - 27 Feb 2008 15:04 GMT

Worked like a charm

Thank You Soooooo Much

Highlight all the cells you want this to happen to (B6:AC6 ?) with B6
as the active cell in the range, then click on Format | Conditional
Formatting and choose Formula Is rather than Cell Value Is in the
first box of the pop-up. In the second box enter this formula:

=B6=MAX($B6:$AC6)

then click on the Format button, select the Patterns tab (for
background colour) and click on the colour you want to use for the
highlight. Then click on OK twice to exit the CF dialogue box.

Hope this helps.

Pete

On Feb 27, 2:47 pm, "phuser" <phu...@sasktel.net> wrote:

> I am trying to use Conditional Formatting to find the Max value in a Row
> using =Max(B6:AC6), having that cell Highlight to a different color but
> the
> =Max is highlighting them all.
>
> Help

Reply to this Message

Pete_UK - 27 Feb 2008 15:42 GMT

You're welcome - thanks for feeding back.

Pete

> Worked like a charm
>
[quoted text clipped - 25 lines]
>
> - Show quoted text -

Reply to this Message

JE McGimpsey - 27 Feb 2008 15:06 GMT

One way:

Select B6:AC6, with B6 active. Then use

CF1: =B6=MAX($B$6:$AC$6)
Format1: <pattern>/<color>

> I am trying to use Conditional Formatting to find the Max value in a Row
> using =Max(B6:AC6), having that cell Highlight to a different color but the
> =Max is highlighting them all.
>
> Help

Reply to this Message

Gary''s Student - 27 Feb 2008 15:07 GMT

Try FormulaIs:
=B6=MAX($B$6:$AC$6) and copy across

This should hi-light the max cell and all cell that have the max value ( if
there are more than one)

Signature

Gary''s Student - gsnu2007d

> I am trying to use Conditional Formatting to find the Max value in a Row
> using =Max(B6:AC6), having that cell Highlight to a different color but the
> =Max is highlighting them all.
>
> Help

Reply to this Message

Paul Hyett - 27 Feb 2008 18:13 GMT

>I am trying to use Conditional Formatting to find the Max value in a Row
>using =Max(B6:AC6), having that cell Highlight to a different color but the
>=Max is highlighting them all.
>
>Help

I asked the same thing here some time ago, and this is what was
suggested:

'Cell value is','Equal to',=MAX(b6:ac6)

Signature

Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message