1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Conditional Formatting Ignore 0

    From [email protected]@21:1/5 to All on Mon Dec 23 15:19:06 2019
    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 x>0 or 1+.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)