ExcelBanter - Conditional formatting - skipping empty/zero cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional formatting - skipping empty/zero cells (https://www.excelbanter.com/excel-discussion-misc-queries/215927-conditional-formatting-skipping-empty-zero-cells.html)

jmj713

Conditional formatting - skipping empty/zero cells

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?

All times are GMT +1. The time now is 04:23 AM.