Add conditional formatting to spreadsheet
Budget: $10 – $30 USD
I require some simple conditional formatting to Excel spreadsheet.
RULES FOR FORMATTING:
DATES BETWEEN 0-14 DAYS AFTER TODAY'S DATE (RED) (for example, between today's date and up to 14 days in the future for example)
DATES BETWEEN 15-21 DAYS AFTER TODAY'S DATE (AMBER)
DATES BETWEEN 22-28 DAYS AFTER TODAY'S DATE (GREEN)
DATES MORE THAN 28 DAYS AFTER TODAY'S DATE (WHITE)
See spreadsheet attached (I have highlighted cells the relevant colours so that you can understand what colours these cells should be once you have created the conditional formatting).
Also, please formulas to the SUMMARY tab to add the total number of each coloured cells
RULES FOR FORMATTING:
DATES BETWEEN 0-14 DAYS AFTER TODAY'S DATE (RED) (for example, between today's date and up to 14 days in the future for example)
DATES BETWEEN 15-21 DAYS AFTER TODAY'S DATE (AMBER)
DATES BETWEEN 22-28 DAYS AFTER TODAY'S DATE (GREEN)
DATES MORE THAN 28 DAYS AFTER TODAY'S DATE (WHITE)
See spreadsheet attached (I have highlighted cells the relevant colours so that you can understand what colours these cells should be once you have created the conditional formatting).
Also, please formulas to the SUMMARY tab to add the total number of each coloured cells