1. conditional formatting (xp)

I have several cells in a named range and I need to change formatting based on highest & lowest (Max & min). I am having trouble getting the correct formula. Can anyone help? see attached small SS.

2. Re: conditional formatting (xp)

YOu can use as the formula for the max:
=AND(ISNUMBER(B3),B3=MAX(\$B3:\$S3))

And for the min
=AND(ISNUMBER(B3),B3=Min(\$B3:\$S3))

Steve

3. Re: conditional formatting (xp)

Thanks Steve. How does the ISNUMBER play in al this? Why wouldn't something like =(B3=MAX(\$B3:\$S3)) work? I am asking because there is no question that value in B3 is a number so why must that be checked for TRUE?

4. Re: conditional formatting (xp)

It would be sufficient to use Cell Value Is, equal to, and =MAX(Totals) and =MIN(Totals), respectively.

5. Re: conditional formatting (xp)

I added the isnumber, presuming that in addition to the total rows, it may be expanded to the other rows. In the case of the other rows, I wanted to prevent it being colored when all the cells in the row were blank...

Steve

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•