Imagine I'm coloring the below polygons in on a map. I want to represent the values using graduated symbology, with the highest value the darkest red and the zero value white. However, I want to express the #N/A value as grey.

Take for example this spreadsheet.

  • Duplicate the layer. In the duplicate use a definition query to limit it to #N/A. Symbolize that as gray. In the original use a definition query to exclude #N/A. Then apply graduated symbology to that layer.
    – John
    Jan 9, 2023 at 23:49
  • In the graded categorie, you can add this formula CASE WHEN "CE" IS NOT NULL THEN "CE" ELSE -100 END, so that it will transform the NULL into -100. Use the color ramp you want and just select grey for the -100 value.
    – katagena
    Jan 10, 2023 at 10:55

1 Answer 1


Apply your graduated symbology, then change your symbology type to Rule-based (the rules will default to the existing graduated symbology, but you can tweak each class if you need after changing), then add a new rule and set it to "Else" instead of "Filter".

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.