MAX from different columns
Nope, still can't get it to work.
Both your solution and Gary''s Students results in ALL seven possibles being
formatted (in red), whereas Peo's idea has only F3 highlighted even though
this cell doesn't contain the highest value.
Ok had a play now
It works by placing:
=C3=MAX($C$3:$C$6,$F$3:$F$5) for the firsf column, and
=F3=MAX($C$3:$C$6,$F$3:$F$5) for the other.
I've tested it and it works (for some reason!)
--
Traa Dy Liooar
Jock
"Gary''s Student" wrote:
=MAX(C3:C7,F3:F5)
--
Gary''s Student - gsnu200755
|