Conditional Formatting

Excel Template With Alerts for Expiry and Renewal Dates

by

This Excel template works out when each policy, subscription or document expires, counts the days left and flags anything Expired or Expiring Soon in colour. Because it uses TODAY, the alerts update every time you open the file. FunctionsEDATE, TODAY and IF AlertsConditional formatting: red for expired, yellow for due within 7 days Works inExcel … Read more

Highlight cells according to current Time in Excel

by

In a timesheet or schedule with dates across the top and hourly slots down the side, conditional formatting with NOW() highlights the cell for the current date and hour, so you can see at a glance where you are in the day. FunctionNOW() ToolConditional formatting with a formula UpdatesWhenever the sheet recalculates The schedule Dates … Read more