Givin color to multiple cells based on values

[VargheseG]

As per the image below i need to provide colur for each cell in the column based in a same formula for er: consider if value in cell is  greter than 40 then red color or else green colur : is there any work around

[cjaneczko]

Are you exporting to excel? Simplest way is to do all of your conditional formatting in Excel and save the file. Then enable Preserve Formatting on the output tool so when the sheet is updated all of the formatting formulas stay when the file refreshes. 

[binuacs · Accepted solution]

@VargheseG one way of doing this using the table tool, first create the table tool with one field then in create the column rules in the "unknown variable", then you can add any more fields in the input file , the formatting in the unknown-variable get reflected to the other fields by default.

[VargheseG]

@binuacs Thanks for the help, the solution worked