You could set up a conditional format for both cells and have an
=IF((A1)="Done",1,0) and conditionally format the second cell so it changes
when the true statement = 1. If you choose not to have the number show up in
the second cell then just format the font to the same color. I did a similar
function in my department dashboard and now all I have to do is enter the raw
data and everything changes colors appropriately. It is a work of art.

"andoscott" wrote:

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?