title: Graded color scale to ignore 0's in Excel
body: <p>I'm trying to use the graded color scale in a pivot table in excel, but I'd like to ignore 0's from the scale. I can easily mask the values with an additional rule, but this doesn't remove them from the scale.</p>
  <p>I've tried setting the minimum value to the minimum I'd like to use, but it doesn't seem to register. I've searched all morning and found plenty of resources for ignoring 0's in other forms of conditional formatting, but not for the graded color scale.</p>