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.
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 🙂
gergelycsaszar , you are welcome