D
Dirty70Bird
Is there a way to use conditional formatting based upon limits that come from
a table? I have many columns in a report, and I would like to format
(highlight it red) a record in a row that is outside those "limits". I can
use the standard conditional formatting in the report, and type in all the
limits for all the columns, but if those limits change, I will have to change
them in the table and in the conditional formatting section of the report. I
would rather type some code in the detail section of the report to get this
to work. TIA!!
a table? I have many columns in a report, and I would like to format
(highlight it red) a record in a row that is outside those "limits". I can
use the standard conditional formatting in the report, and type in all the
limits for all the columns, but if those limits change, I will have to change
them in the table and in the conditional formatting section of the report. I
would rather type some code in the detail section of the report to get this
to work. TIA!!