Conditional Formatting

How can I have a row change color if a cell in that row is left blank for more than 40 days?

I send out invoices to customers and they have 40 days to pay. I would like the row to change color when the “Date Paid” column is not filled in by that time.

 

Thank you.

By: Sarah

Leave a Reply

Your email address will not be published. Required fields are marked *