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