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
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