I seek to create a conditional format on a spreadsheet which logs invoices on the date they were received. Below is the sample
I want to create a conditional format where the 'date invoice received' cell turns orange when 9 days have passed. The other condition which MUST be satisfied for the cell to turn orange is for there NOT to be a "Y" value in the first column, meaning the invoice was paid.
So both the invoice should be received and showing a received date, and second it should not be Paid: blank value in column A. Thirdly 9 days should pass since the received date for the 'date invoice received' column cell to turn orange.
How can I do this?