I have created a gannt in excel.
I have three separate sheets.
1. Gives all information about the project and a timeline.
2. Automatic registration of working hours (using dropdown menus)
3. A sheet that is generated by sheet 2 and contains all working hours.
I have made an automatic registration of working hours.
This is generated in a separate sheet.
Then i want a cell to change color in my first sheet in at a condition.
Example if a date generated in row 1 and the task name is generated on the same line. Then color a cell in sheet one automatic if the conditions are met.
Is there an easy way to do this?
Excuse for my bad English. Not my native language
Bookmarks