I am trying to use green, yellow, and red visual cues for a specific field. I need it to result as green when my field: Cont_Type is a certain number. The only thing I can get it to result back in is the normal field yellow.
I need it for all my container types though. They all have different fields that they need to meet for the upper field and lower field. I wanted to have a pivot table instead of 5 or 6 different boxes for each container type.
I know it will work if I single them out, it just doesn't work with them all together.