I'm trying to create an excel spreadsheet to manage a property but I'm having difficulties in creating rules.
Here's the schedule I'm making
As you see, I have in H4 the date the cheque is due, and in I4 the status (a drop down list of either "Pending" or "Paid" )
I want a rule that says, If the date is overdue (from Today), and the status is Paid, the H4 shall turn Green, or even if the date is not overdue yet as long as the status is paid the H4 shall turn green.
Another rule that says, If the date is overdue, and the status is Pending, the H4 shall turn Red.
and the final rule says if the date is not overdue yet, and the status is pending, H4 shall turn Orange.