Pages tagged “conditional-formatting”

3 pages in Cellwise.

1. Budget vs actual: variance, percent and an Over/OK flag

   Variance in money and percent, an Over/OK flag, and a total, with no divide-by-zero error.

   budget finance conditional-formatting

2. Flag overdue invoices and colour the row red automatically

   A TRUE/FALSE overdue test and how to use it as a conditional formatting rule in Excel and Google Sheets.

   invoice conditional-formatting freelancer

3. Highlight overdue invoices automatically in Excel and Google Sheets

   One conditional-formatting formula that colours every unpaid invoice past its due date.

   invoice conditional-formatting freelancer

All pages