01-14-2025 09:55 AM
I'm at my wits end. I have scoured through so many posts on here (and throughout the Googleverse) dealing with changing the background color and/or font color of individual cells in a REPORT table. I have tried all the examples I've found, all the scripts that I have come across, and I have yet to get the results I'm looking for. DIAdem really makes this task inherently difficult.
Below are two examples of what should be simple things I want to accomplish.
In the left example, if "None" appears in any cell, change the background color. If "N/A" appears in any cell, change the font color. In the right example, if a cell has a particular value, change the background color.
Again, simple tasks (and I've really tried my best to get this to work in the REPORT tables), but I have had no luck. I'm using version 2023 Q2, if that helps.
01-16-2025 03:18 AM
Unfortunately, this is a bit tricky in DIAdem. To change properties of individual cells you have to use the OnDrawingCell event. There is an example in DIAdem help under Examples - Creating a Report - Tables - User command (to be honest - I only found it as I knew it should be there 🙂).