Cell shading based on conditions

[Brad1982]

Hrmm it doesnt seem to shade any of the

 

[Guest]

Hi
..- in what cells are your data values stored
- hwat cell sdid you select before going to the conditional format dialog
- what is the exact formula you have entered

 

[Dave Peterson]

It worked ok for me for row 1. Did you remember to make a change to the format?

But if you have multiple rows that should have this, I'd modify Frank's
instructions slightly.

Select B1(whatever)

And with the activecell B1, use this formula:
=B1=MAX($B1:$D1)

And it'll automatically adjust for the other rows.