Conditional Formatting on Heat map

[Former Member]

Hi,

I have a requirement for Heat map conditional formatting and here I see options are available only equal to, greater than and less than only.

If I have requirement like if value is 0 (red), <21 (orange), <=56 (yellow), >56 (green).
So in this case how I can define >21 and <=56 is yellow?

Thanks,

AP

[TammyPowlas · Accepted solution]

AP -

Try

= 0 (red),

<21 (orange), < 57 (yellow), >56 (green).

[Former Member · Accepted solution]

Thanks Tammy Powals, that worked out good.