Conditional formatting - skipping empty/zero cells

J

jmj713

I have a conditional formatting rule set so that a range of cells is colored
according to their value: red for lowest, green for highest. But there may
also be blank or zero cells in that range. Is it possible to somehow adjust
the rule to skip such cells?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting in Excel 2003 2
Formatting row color in table to match first cell in first column 0
Conditional Formatting & Macro 0
Conditional Formatting Help in Office 2007 4
Conditional Formatting and Formulas 1
SUMCOLOR with conditional formatting not working 3
Conditional formatting disappears when cell contents deleted 2
Conditional Formatting Across Multiple Cells 0

Top