I am trying to create a project timeline for a new restaurant and want to have the cell auto colour based on the status in the previous cell/column.

For example if the cell previous has "Done" written inside, the next cell will color green
I wish to have 3 status and 3 colours
Done Green
In Progress Yellow
Nil Red

As always your help is greatly appreciated