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

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History