# Plot a table with custom rule based color in background
**URL:** https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844
**Category:** Kibana
**Tags:** kql-kibana-query-language
**Created:** [November 14, 2022, 9:32am UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844 "2022-11-14T09:32:24Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Tukaram](https://discuss.elastic.co/u/Tukaram)
#### Post date: [November 14, 2022, 9:32am UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/1 "2022-11-14T09:32:24Z")
Hi,
I want to plot a table with custom rule based color for each cell. so, for below table, if debt is more than income, it should be red. if income is more than debt, it should be green. is this possible? how?
---
### Author:  [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [November 14, 2022, 2:28pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/2 "2022-11-14T14:28:01Z")
Hi @Tukaram, I don't think that the solution you're aiming for is possible, but you could achieve similar effect using runtime field. You could create a custom runtime field that calculates the difference between the two:
and then color this in your visualization:
Let me know if this is helpful.
---
### Author:  [@Tukaram](https://discuss.elastic.co/u/Tukaram)
#### Post date: [November 14, 2022, 8:00pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/3 "2022-11-14T20:00:36Z")
Thanks, how you are setting custom color here? I can push diff as separate field as well.
---
### Author:  [@Tukaram](https://discuss.elastic.co/u/Tukaram)
#### Post date: [November 14, 2022, 8:01pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/4 "2022-11-14T20:01:25Z")
I mean, are these colors rule based? for positive, its green and negative its red?
---
### Author:  [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [November 14, 2022, 8:13pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/5 "2022-11-14T20:13:16Z")
You can configure it by clicking on the dimension button from the config panel on the right side and then on 'color', for example that would be a config for two ranges (smaller than zero and equal or bigger than zero):
---
### Author:  [@Tukaram](https://discuss.elastic.co/u/Tukaram)
#### Post date: [November 15, 2022, 11:14am UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/6 "2022-11-15T11:14:26Z")
I am using 7.16.2 and dont see any option for 'color by Value' or color after text alignment.
---
### Author:  [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [November 15, 2022, 12:41pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/7 "2022-11-15T12:41:24Z")
That's strange, the [feature was released in 7.14](https://github.com/elastic/kibana/pull/95217). Are you sure you're clicking on the right dimension? Could you paste a screenshot of what you see?
---
### Author:  [@Tukaram](https://discuss.elastic.co/u/Tukaram)
#### Post date: [November 15, 2022, 1:42pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/8 "2022-11-15T13:42:40Z")
this is what all I got.
---
### Author:  [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [November 15, 2022, 1:58pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/9 "2022-11-15T13:58:27Z")
Are you checking the right dimension? In the example below, it's 'metrics' you should be looking at, not rows.
---
### Author:  [@Tukaram](https://discuss.elastic.co/u/Tukaram)
#### Post date: [November 15, 2022, 2:45pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/10 "2022-11-15T14:45:03Z")
Well, interesting, I could not find that option on existing fields but tried adding new and its there. Great! will give it try.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 13, 2022, 2:45pm UTC](https://discuss.elastic.co/t/plot-a-table-with-custom-rule-based-color-in-background/318844/11 "2022-12-13T14:45:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.