How to highlight the line if the order is overdue?

Question

excel

Hello everyone, I have a question.

There is a table with orders, it has 3 important parameters (order date, date of delivery, and a checkbox that the order was handed over)

For example, I need that if today is July 30, and the delivery of the order was July 29, and the "ready" checkbox is not pressed, all cells of this order were highlighted in red. If the checkbox is pressed, no action is required.

It is necessary that this somehow works every day, that is, the table takes today's date somehow after the fact.

Answer 1

Select the desired range, starting from A1 - Conditional formatting - Custom formula
=И( (A1>СЕГОДНЯ()); НЕ(A3))