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.
You may apply the rule to your entire range (e.g. D2:E1000) with rue formula
=($D2<TODAY())*($E2="")- thank you very much. I have tried but it didnt't work. can you please have a look at my post above with the excel sheet attached? thanks a lot!
Please check in attached file.
