Hi all, I’m trying to change the fill color of a rectangle based on 2 boolean values in Excel. The scenario involves changing the color of the rectangle representing a storage unit in a storage building. Is it rented or not.
There are 2 columns “isRented” and “isRentable.” I’d like to do something like:
If isRented=True make the color gray. If isRented=False AND isRentable=True make the color green.
Does anyone have any idea if this is possible and if so, how would you accomplish it?