G
Guest
Im making a project plan in excel.
Letc say Ive got 10 different cells (10 different tasks) that each of them
needs to filled with a date when the individual task has been completed. I
have in the end a summary of yet another 10 small cells each corresponding to
the other 10 cells (this for a qick overview)
So if the first task has been completed the user filles out the date AND
then I want the small cell to turn inte the colour GREEN, how can you do this?
I would also want that if there is NO text in a cell the small cell should
be default orange colour.
thanks for any help!!
Letc say Ive got 10 different cells (10 different tasks) that each of them
needs to filled with a date when the individual task has been completed. I
have in the end a summary of yet another 10 small cells each corresponding to
the other 10 cells (this for a qick overview)
So if the first task has been completed the user filles out the date AND
then I want the small cell to turn inte the colour GREEN, how can you do this?
I would also want that if there is NO text in a cell the small cell should
be default orange colour.
thanks for any help!!