# Using conditional formatting for Kibana Visualization Data Table
**URL:** https://discuss.elastic.co/t/using-conditional-formatting-for-kibana-visualization-data-table/137590
**Category:** Kibana
**Created:** [June 27, 2018, 9:53am UTC](https://discuss.elastic.co/t/using-conditional-formatting-for-kibana-visualization-data-table/137590 "2018-06-27T09:53:52Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Sandeep\_Kumar2](https://discuss.elastic.co/u/Sandeep_Kumar2)
#### Post date: [June 27, 2018, 9:53am UTC](https://discuss.elastic.co/t/using-conditional-formatting-for-kibana-visualization-data-table/137590/1 "2018-06-27T09:53:53Z")
Hello,
I want to add conditional formatting like excel based on certain field value to color code the cells.
How i can achieve that. e.g. If field value is yes, I want green and if it is no I want in to red color.
Need urgent help.
Thanks.
---
### Author:  [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [June 27, 2018, 5:14pm UTC](https://discuss.elastic.co/t/using-conditional-formatting-for-kibana-visualization-data-table/137590/2 "2018-06-27T17:14:48Z")
Since you mention cells, I'm assuming you're trying to do this for a table vis. That's not something Kibana can do, at least right now. You can kind of do this with the metric vis, but it only adjusts the color based on number ranges, not values as you're trying to do.
Canvas can do what you're looking for, though not yet in its table view. But you could show colored text, or an image, or a number of other things based on some conditional logic. It's currently in technical preview, and you can find out more about it here: [http://canvas.elastic.co/](http://canvas.elastic.co/)
We're exploring to using the same underlying functionality that makes Canvas work in Kibana visualizations, but that's still very much a work in progress right now. So while you can't do exactly what you want today, it's something we're working on.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 25, 2018, 5:14pm UTC](https://discuss.elastic.co/t/using-conditional-formatting-for-kibana-visualization-data-table/137590/3 "2018-07-25T17:14:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.