Can you change the color of one cell based on the color of another

[Guest]

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?

 

[PCLIVE]

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.

 

[Guest]

Not directly by looking at the colour but you can look at the condition in
your first cell to change your second cell. For example say you set A1 to
green when A1 is >75.

In C1 you can also look at the value of A1 and change the colour using the
same condition this time using a formula. Select C1 and conditional
formatting - formula is =A1>75.

Any good?

Mike

 

[Guest]

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.

 

[David McRitchie]

I have a page on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

and you might be looking for a sum in a range to
match or exceed a value, for each item to marked somehow.
=SUM(B2:F2)>= 100
or that there are no empty cells
=COUNTIF(B2:F2,"completed")=5