Girls without lipstick are never be assumed. The girls who can not afford the full set of makeup kits. They can at least use the lipstick always. Not only a girl, but a woman of every age also love to apply lipstick. In ancient days there were only creamy lipsticks. After that, matte lipsticks are invented. And in recent years, liquid lipsticks have become widespread. But the budget matters. There are so many college girls who can’t save their pocket money more than 100. Especially for them, this article will help you to get liquid lipstick under 100 only.

To solve your problem, please apply the below formula:

Please try, thank you!

=IF((AND(AA1="Occupied",AA2="Occupied",AA3="Occupied",AA4="Occupied")),"Occupied","Vacant")

I need the tab to be red if "Occupied" and green if "Vacant". However the code above in the main post doesn't recognize the output of the If Than