Multiple Visual Expressions

You can use IIF formulas in visibility, so you could try something like this with multiple IIF statements...

= IIF(([LineNote.NoteText]<>Null And [LineNote.NoteText]<>''), IIF([$LineNbr] % 2 = 0, TRUE, FALSE), FALSE)

Unfortunately this will break your color coding though. Just because it isn’t visible, doesn’t mean it doesn’t calculate your LineNbr variable. You’ll have to attach some sort of logic to your LineNbr variable, like so:

= IIF(([LineNote.NoteText]<>Null And [LineNote.NoteText]<>''), $LineNbr +1, $LineNbr)

This way it will keep the variable the same if it is not printing that section, making sure your colors alternate properly.

Edit: Do this on top of what ​@bwhite49 said to do for the visible expression

Hi ​@JReppard,

Use =IIf([LineNote.NoteText] <> Null And [LineNote.NoteText] <> '', IIf([$LineNbr] % 2 = 0, 'Color1', 'Color2'), 'Hide') in the visibility or formatting expression.

Hope this helps.