I am having a heck of a time. So I have two existing conditional formatting rules for this drop-down field. One makes a field turn yellow if the selected option is either “-” or “” (blank). The second rule turns the background green if the expression is “Complete.” The drop-down list has like 100 more selectable options, and I want a rule that will turn the field red if any are selected other than “-” , “” , or “Complete” but I can’t seem to get it to work by using <>. How can I write this final rule? Thanks!
Get the best Microsoft Access conultant
Get the best Microsoft Access programmer