Condtional formatting in Excel

Microsoft Excel 2010 - complete product...
October 19, 2011 at 12:49:40
Specs: Windows 7
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.

See More: Condtional formatting in Excel

Report •

October 19, 2011 at 17:08:25
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.

Report •

October 20, 2011 at 14:46:42
That would work except that I need to exclude the cells containing zero in the choosing

Report •

October 20, 2011 at 15:11:33

Report •

Related Solutions

Ask Question