In this article we discuss how to add conditional formatting to your report.
The following syntax can be used as an example to quick start your conditional formatting challenge:
A. {d.REPORT_Risk_Report.System[i].isriskfor_Risk_reverse[i].has_Quantification[0].score:ifGT(5) :show(#FF0000) :color(cell,background)}
B. {d.REPORT_Risk_Report.System[i].isriskfor_Risk_reverse[i].has_Quantification[0].score:ifGTE(10):and:ifLT(20) :show(#FF0000) :or(.score):ifGTE(20) :show(#0395FF) :color(cell,background)}
To learn more, please watch the below instruction video.
Contents
0:00 Introduction
1:35 Starting point
2:35 Adding conditional formatting
5:30 Handeling error messages
6:30 Multiple conditions
10:00 Documentation