Hi
try the following (for a row based formating)
- select your range (e.g. rows A1:X10)
- in the contional format dialog enter the following formula
=A1=MAX($A1:$X1)
- choose a format
..- repeat for the minimum:
=A1=MIN($A1:$X1)
--
Regards
Frank Kabel
Frankfurt, Germany
Paul Rampenthal wrote:
Thanks Frank, to further complicate matters I am trying to highlight
the highest/lowest cell value in a row. So each row would require a
separate formula. Is this possible?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!