ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Formatting Ignore 0 (https://www.excelbanter.com/excel-worksheet-functions/454523-conditional-formatting-ignore-0-a.html)

[email protected]

Conditional Formatting Ignore 0
 
I have a list that automatically adds columns and displays the answer, which leaves 0s for the rest of the rows that are not filled in yet. I am using the Color Scale Conditional Formatting, and I want it to only count x0 or 1+.


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com