B
Brad1982
Hrmm it doesnt seem to shade any of the
F
Frank Kabel
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
..- 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
D
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.
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.