Max Value

  • Thread starter Thread starter phuser
  • Start date Start date
P

phuser

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
 
phuser said:
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.
Click to expand...
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
 
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
 
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
 
One way:

Select B6:AC6, with B6 active. Then use

CF1: =B6=MAX($B$6:$AC$6)
Format1: <pattern>/<color>
 
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)
 
You're welcome - thanks for feeding back.

Pete

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




- Show quoted text -
Click to expand...
 
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
Click to expand...
I asked the same thing here some time ago, and this is what was
suggested:

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