How can I change a cell value based on another cells color?

[Guest]

I have many different values on a large spreadsheet. I am wondering if there
is a way to change a cell value to match another cell value based on the
second cells color? For example, I would need to change cell A1 to a value of
10 so it matches cell A2's value of 10, because cell A2 is highlighted in
green. I am not familiar with macros, is this something that would require a
macro?

 

[Debra Dalgleish]

There's no built-in feature that will change a cell's value based on the
colour of another cell. You would need to use code to accomplish this.

Chip Pearson has information on using colours in functions. Maybe it
will help you get started:

http://www.cpearson.com/excel/colors.htm

 

[Earl Kiosterud]

Jeremy,

Applying color, then acting on it is not really the way Excel is designed.
See www.smokeylake.com\excel\excel_truths.htm. Read "Color as data."