Duplicate conditional formatting to other tables

[shainis]

Hi,

I have this table:

with the following conditional formatting (the same for each on the columns):

Is there a way to duplicate this formatting to other tables? I have a lot of tables and I hope not to rewrite these rules again and again 🙂

Thanks!

[amitchandak · Accepted solution]

@shainis , You can create a color measure and then use that is conditional formatting using field value option

examples

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

Refer my video for steps

https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=14