I am trying to do the following: If a date is in cell A1, B1, C1 and then I
would like to have D1 color codes green, if a date is in A1 and B1 and
nothing in C1 I would like cell E1 to be colored yellow and so on.

I work for a business and we will be using a date table to show the progress
of a project. We are looking for a simple way to show the status of each
project by using colors. Red meaning urgent, green OK and yellow some work
still needed.

Anyone have any suggestions?