How to create color rules for all columns with the same prefix?


I know how to set color rules for each column in a table. However, the data keeps updating and I might need to keep track of the data and create new rules when there are new columns.

To have zero maintenance reuqired on my report, I'm seeking a way to set color rules for all columns with prefix 'DF' using IronPython:

When the date in column DFxx1 is the same as the date in the 1st row, set (1,2) to yellow, otherwise set (1,2) it to red...iterate this this process for all items in this table.

  1 2 3
1 last_modified(timestamp) DFxx1 DFyy2
2 mm/dd/yyyy mm/dd/yyyy mm/dd/yyyy
3 mm/dd/yyyy mm/dd/yyyy mm/dd/yyyy


I think I first need to use regular expression so I tried the solution in this page:

However, I got this this error message:

"Exception: Could not find column 'myTable.cname'."


Now I am stucked, and don't know how to move on...could anyone help me?


Image icon test_table.jpg81.83 KB

(1) Answer