Hello,
I am trying to create a conditional formatting expressing with multiple variables, but can get the last piece to fit. Basically I want a date field to turn red when one of two other fields is not present and if the date is overdue. The first field is a check box the other combo box. Here is the expression I thought I could use...
IIf([Revocation Appealed]=False,"n") Or IsNull([Revocation Outcome]) And [Appeal By]<=Now()
I want the outcomes to be:
if checkbox is empty and combox box empty and date overdue = red
if either the checkbox or combo box have values = black
if checkbox empty and combo box is empty and date not overdue = black
having either the checkbox or the combox box with values meets the criteria of the item not being overdue and I can get it to work with one or the other but not both... any help would be greatly appreciated!