How do I compile a table in MS Excel with a timeline?
I work on a farm where we produce and export pineapples. Such pineapple cultivation needs utmost accuracy. I have now been asked to design and implement a table which will capture all activities on each plot comprehensively with dates given to each activity. I want to develop a table which will automatically highlight activities as "pending", "completed" and "undone" for which I will use different colors. The challenge i have is that I need Excel to automatically highlight the fields at given times in order for jobs to be carried out on time.
How can I do this, and is Excel even the program to use?