View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] lewisorigami@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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+.