Conditional Formatting - nulls and automatic backcolor
Two things for Conditional Formatting: (1) Add options for Field Value is null/not null. Doesn't work if I say Field Value Is equal to Null, instead I switch to Expression and type it out. (2) Background color needs a "transparent" or "no color" option. Example- I have a report with alternate row colors and want to highlight a field with solid yellow for certain conditions and make it clear for others... using the "Automatic" background color makes the field solid white instead of whatever the alternate row color is.