I have a drop down list on a form that I cannot get conditional formatting to work on (I want to color the field if text is not equal to certain phrases)

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!

submitted by /u/MrManager689
[link] [comments]

Get the best Microsoft Access conultant

Get the best Microsoft Access programmer

Posted on