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!!

use Conditional FOrmatting. See:

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


--
Gary''s Student
gsnu200710


"terence" wrote:

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!!

Format/ Conditional formatting/ Formula is: =NOT(ISBLANK(A1)) .
Other options are =ISNUMBER(A1) if the date is entered as a number, or
=ISTEXT(A1) if it is text.
--
David Biddulph

"terence" wrote in message
...
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!!

Color the cell as orange, so this becomes the 'default' color. Then,
Format-Conditional Formatting. Then specify Condition 1 as Cell Value is
not equal to "". Click on Format button and specify the green backgroun.

"terence" wrote:

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!!