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

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PCLIVE" wrote in message ...
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?