Forum Discussion
Excel 2016 Conditional Formatting - Multiple Tabs
I have a spreadsheet that has over 100 tabs on it. The tab I want to format is our Balances tab, which shows which invoices have not yet been paid (high level view of what's outstanding). This Balanc...
You could use a formula similar to the one you currently have to get the balance to extract the due date from the information. Then it'll be easy to base a CF rule on that newly inserted column.
PS: As you have noticed, your multi-worksheet setup makes it hard to do cross-client reporting. Having the information of all invoices on a single tab would have made this a relatively straight-forward task.
PS: As you have noticed, your multi-worksheet setup makes it hard to do cross-client reporting. Having the information of all invoices on a single tab would have made this a relatively straight-forward task.