Good afternoon,
I have a continous subform on a form where I need to use conditional formatting to change the colors of a combo box based on the value selected. The data type of the values are all short text.
Combo box drop down is [Item_ID] selections I want to affect are SWA, BH, FREIGHT (and a few others but you get the idea)
I know how to use conditional formatting a little bit. But I want to know if any of these codes will work, or how if I need to make individual rules for all of the selections I want to be affected.
These were my ideas, but I am not sure if the OR, or a , is how I should separate the values if either of these is right at all.
Expression is [Item_ID] = "SWA" OR "BH" OR "FREIGHT"
Expression is [Item_ID] = "SWA" , "BH" , "FREIGHT"
I am unable to make edits to the system at this time or I would just use trial and error.
Any advice is appreciated.
Thank you!