Forum Discussion
Solved
Conditional formatting help needed
Hi all, I'm trying to set up a rule for conditional formatting but kind of stuck. I have a sheet with a list of invoices. I want to highlight rows that are past due date and haven't been paid...
Please check in attached file.
Hi Greg,
You could Use the formula as shown below.
Note that dates are franche formated in this picture, and that references to E2 and D2 are relative so that the formula can work for every selected cell.
Hope this helps!
thank you for the quick reply, however I couldn't manage to apply the rule properly. I have attached a slimmed down version of the XLSX, can you please have a look and let me know what I missed? I would like to highlight the entire row where the date is before today AND there is nothing in the "PAID" column.
thanks a lot
Here is your file with the conditional format formula.
SergeiBaklan formula would also do the trick.
Use the one you prefer!
- awesome, thank you very much. is there a way to highlight the whole row not just the cell?
