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