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

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?

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

-----Original Message-----
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?
.

Use conditional formatting.


--
nbrcrunch