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.
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?
Full row is highlighted, please check the file.
As a comment, I'd convert your range into structured table (Ctrl+T), when rules will be expanded automatically.
- thank you very much. it all works now 🙂