Tips:Highlighting report cells with no data

Have you ever produced a report and needed to highlight cells with no data to make sure that they don't get lost/missed?

If so, you can take advantage of the fact that you can use formats to specify the style attributes for a cell. Typically this is done to provide traffic highlighting of values (e.g., show different ranges in different colors).

In the example shown at right a format is created to map missing values to yellow and all other values to white. The format is then used to provide the background color for the cell. This results in cells with no data being highlighted in yellow.