I'm becoming very dependant on this forum to help me...I'm hoping someone knows the answer to my problem.
I have a table where one of the fields is a drop down menu with four choices. I would like another field in the same table to change color if any one of three of the four choices in the drop down menu are selected. For example, if choice A, choice B or choice C are selected Field X turns red. If choice D is selected Field X stays the same color.
I'm sure this can be done but despite a full work day looking for the answer I can't seem to find one.
Thanks for any help that can be provided.