How do I write a formula to color code based on dates provided or.

[Guest]

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?

 

[Jason Morin]

You can apply conditional formatting to 1 or more cells,
and have them change color depending upon the results in
other cells. Using your first request as an example,
select D1, go to Format > Conditional Formatting,
select "Formula Is" on the drop-down and insert:

=COUNT($A$1:$C$1)=3

Press the Format radio button and format as desired. To
learn more, see:

http://www.contextures.com/xlCondFormat01.html

HTH
Jason
Atlanta, GA