Making an Answer's Text Red on a Report

How to make an answer's text red on a report

You can highlight an answer in a report with a color—for example, showing red for "No" responses. Here's how to accomplish this:

1. Click on the FormAnswers field on your report.

2. On the right-hand side, click the Expressions icon (𝑓).

3. Expand the Appearance section by clicking the arrow next to it.

4. In the Foreground Color field, click the three dots (...).

5. Enter the following expression, replacing the field name with your specific one:

   Iif([Form Answers.Are valves accessible - Inspection Check] == 'No', 'Red', 'Black')


Note: You can adjust this expression to use different colors or even apply it to the Background Color field instead of Foreground Color.