Hi,
I have attached a file with a "campaign tracker".
campaign_tracker_example.xlsx
Screenshot_042114_012108_PM.jpg
Idea: After entering your campaign name, launch date and end date, it is meant to help display a calendar where these important dates are marked with conditional formatting in different colors.
Problem: I need this calendar to be able to scale above 1000 rows, possibly 5000. When simply "filling down" with the below formula, the file becomes very sluggish.
Request:
- Help me re-write the formula to an Array-Formula or similar to make the file fast and small-sized.
- Possibly incorporate the in-cell formula(creating number values) into ONLY conditional formatting to do the entire job of finding/checking/coloring cells.
The calendar cells have a function checking for dates and entering a number:
- If column date equals start date type "1"
- If column date equals start date minus 3 days type "2"
- If column date equals start date plus 1 type "3"
- If column date equals end date type "4"
- If column date equals end date plus 1 type "5"
- If column date is between start and end dates enter "6"
- If column date is between start and end dates enter "7" for every 7th day inbetween
After this, conditional formatting applied to the area then checks for these numbers entered and adds background color to the cells.
Looking forward to hear your ideas and suggestions on this! Many thanks in advance!
/Henrik
Bookmarks