# Conditional Formatting - Comparing multiple columns

**URL:** <https://community.plotly.com/t/conditional-formatting-comparing-multiple-columns/44967>\
**Category:** Dash Python\
**Created:** [September 16, 2020, 11:15am UTC](https://community.plotly.com/t/conditional-formatting-comparing-multiple-columns/44967 "2020-09-16T11:15:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SJay](https://avatars.discourse-cdn.com/v4/letter/s/c37758/32.png) [@SJay](https://community.plotly.com/u/SJay)\
**Post date:** [September 16, 2020, 11:15am UTC](https://community.plotly.com/t/conditional-formatting-comparing-multiple-columns/44967/1 "2020-09-16T11:15:27Z")

</div>

I have a data table and I’m trying to conditionally format one of the columns (say ‘status’) based on some other numeric columns (‘A’, ‘B’, ‘C’, ‘D’). This is what I tried:

```auto
style_data_conditional=[
{'if':
      {
        'filter_query': '{A} = {C} && {B} = {D}',
        'column_id': 'status'
      },
     'color': 'rgb(50,205,50)'
}
]

```

But this gives me the following error:  
**DataTable filtering syntax is invalid for query: {A} = {C} && {B} = {D}**

What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![AnnMarieW](https://avatars.discourse-cdn.com/v4/letter/a/ec9cab/32.png) [@AnnMarieW](https://community.plotly.com/u/AnnMarieW)\
**Post date:** [September 16, 2020, 6:13pm UTC](https://community.plotly.com/t/conditional-formatting-comparing-multiple-columns/44967/2 "2020-09-16T18:13:23Z")

</div>

Hi @SJay

I don’t get an error message when I use this syntax.

There were some new features added to conditional formatting in v1.12. What version of Dash are you using?