How to do Conditional format for the Values ?

bhaveshp90 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the table as shown below; where I used the ColorMix wizard for the "Net" field in my table. (Higher Values - Red and Lower Values - Green)

I want the color formatting only to my upper and lower values, not the middle values as shown in the image below;

Desired Output:

How do I achieve this, any help is appreciated.

thanks

Bhavesh

Re: How to do Conditional format for the Values ?

bhaveshp90 — Tue, 09 Oct 2018 20:23:08 GMT

Assign 0 to the intermediate expression in the ColorMix wizard which gives the desired output as shown below;