"Case" Structure Colors

"Case" Structure colors will change the cell color and text color of the displayed booking depending on the value stored in a field that you select in the Field with Condition prompt.  You can have as many as you need.  The template does a case statement on the field and uses UPPER and CLIP so it is not case sensitive and ignores trailing spaces.

Add the condition value to use and colors to use for that value in the Booking cells.  No quotes are needed, the template adds them for you.

"IF" Structure Colors

The template will generate "IF" statements using your conditions.  You need to have the variables and quotes right on these.

"IF" condition is an Expression prompt, so you can look up the variables with the button.