# Conditional colouring using kibana canvas expression editor

**URL:** https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929
**Category:** Kibana
**Tags:** canvas
**Created:** [April 23, 2019, 3:42am UTC](https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929 "2019-04-23T03:42:57Z")
**Posts on this page:** 1
**Showing post:** 17

<div class="post-metadata">

### Author: ![sharonva](https://avatars.discourse-cdn.com/v4/letter/s/50afbb/32.png) [@sharonva](https://discuss.elastic.co/u/sharonva)
#### Post date: [June 19, 2019, 12:30pm UTC](https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929/17 "2019-06-19T12:30:04Z")

</div>

Hi tims,

I have the same problem as Scott , trying to change background color by condition and it doesnt work. Here is the code snipet:

filters  
| essql  
query="SELECT  
count("eai\_sts\_proc") AS cnt  
FROM  
"logit-exampleindex-\*"  
WHERE  
app\_name = 'EXAMPLEAPP'  
AND  
command = 'EXAMPLESERVICE'  
AND  
eai\_sts\_proc= 'OK'  
AND  
"@timestamp" \> NOW() - INTERVAL 5 MINUTES"  
| math "cnt"  
| metric ""  
metricFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=24 align="center" color="#000000" weight="bold" underline=false italic=false}  
labelFont={font family="'Open Sans', Helvetica, Arial, sans-serif" size=14 align="center" color="#000000" weight="normal" underline=false italic=false}  
| render  
containerStyle={containerStyle backgroundColor={if {lt 1} then="red" else="green"}}

it is always else and showing a green background  
Thanks

---

_[View the full topic](https://discuss.elastic.co/t/conditional-colouring-using-kibana-canvas-expression-editor/177929)._