Conditional Color Change

Another way to simplify the problem could be to have one single variable with 3 values:

  • Rented
  • Not Rented & Not Available
  • Not Rented & Available

Thus you only have 1 column to look at, whether it contains a “rent” value or a hex color.