Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional formatting with only Negative Numbers with different Backcolours

I want to use different backgroundcolours for different RSSI values. (-90 DarkRed)(-60 Yellow) (-50 Green), but it seems negative numbers get only one fixed backgroundcolour as result. How can I solv...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I found the problem thanks to your answer where you mention Sum, I just realised I forgot to make the Column a Integer and it was still a String. I think I overlooked it in the haste.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario.

Table:

 

Then you may create a table visual, click 'RSSI' field =>'Conditional formatting'=>'Background color'.

 

You may choose 'Format by Rules' and set as below.

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.