Highlight blank field within a report?

Hi Kelly,

In order to highlight an individual field you'll have to create a Rich Text Formula that will look at your field of interest.  This can be a Report Formula or an actual Field in your table.

Here's a very basic example:

var text emptyStyle = "<span style='background-color:yellow;'>";

If([Medical Provider] = "", $emptyStyle, "<span>")

&[Medical Provider]

&"</span>"

This is assuming [Medical Provider] is a text field.  If numeric (like a Related or Cost field) you can use the isNull() or Nz() functions