I have a list of numbers that is currently formatted to turn the text of the highest number green. I also need a formula for the same set that will turn the lowest number, excluding the zeros, red. I'm looking for either a formula that will perform both functions or one that will add to the current formatting.

Just add another Rule based on your new criteria. I assume that you are using the MAX function for green...what's the opposite of MAX?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

That would work except that I need to exclude the cells containing zero in the choosing

=A1=MIN(IF($A$1:$A$5<>0,$A$1:$A$5))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History