Autofill a Cell on Sheet 2 with a Value from a Colored Cell on Sheet 1- Is this Possible?

[beachbum07]

I want to auto populate a call with the value of a different cell that has been colored on a different page.

Example:

1.) On Sheet 1, Cells range A1-A10 have values to choose from
2.) I choose A7 and change the cell color to gray
3.) It auto populates Cell B1 on Sheet 2 with the value of the gray colored cell I selected on Sheet 1

Is this possible?

[Pepe Le Mokko]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-gene...-possible.html

[beachbum07]

Sorry I thought you could post in different forums... like general or formulas.. There is a third one I just posted not knowing..