You should look into Conditional Formatting for both cells. There would
need to be a column or something that you mark to indicate that a item is
complete. That would be the easiest way to accomplish both tasks.


"andoscott" wrote in message
...
I have a list of items to be completed in one column. As the items are
completed I color the cell green. There is another column that I would
like
to color green as the items in the first column are colored. Is there a
way
to link the colors of the cells so that when I change the color of one
cell
the color of another cell changes also?