How to do Conditional format for the Values ?

[bhaveshp90]

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

[bhaveshp90 · Accepted solution]

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