Dynamic color coding with more than 100+ columns

faisal9999

I have small data attached this is just sample with date, and string columns ABC....I have 100+ column, Now I want to do color coding on each and every cell if any cell = 0 then Green and else Red. 

I have tried on Basic Table but as I have more than 100 column so can not apply formula on 100 columns as it will time.

please help if you can. thanks

colord code image.png

griffinwelsh

@faisal9999

1.drop a table tool onto your canvas but do not connect the input anchor

2.create your column rules for Dynamic or Unknown Fields. Use formula [_CurrentField_] = 0 for your green color and [_CurrentField_] != 0 for your red color

3.connect your input and the dynamic rules will apply to all columns