Using variables in conditional formats
If you use a variable in a conditional format (for example,
ReportVariables.MyVariable.Text="True"), the format does not change when the value of the variable changes. The format changes only when the report is recalculated.
A solution is to insert the variable into any cell in the report (for example, in a hidden column or row) as well as in the condition. The format changes immediately when the value of the variable changes, without recalculating the report.