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?

[beachbum07]

Just brain storming...

is there a away to search for a colored cell in a cell range and auto populate another cell with the value of the found colored cell?

[beachbum07]

If you can do conditional formatting to change the color of a cell based on the value, why can't you auto populate a cell value based on the color of another cell?

[newdoverman]

Conditional formatting is just formatting based on criteria. It doesn't have the capability to "push" values into a cell.

What you want might be possible with VBA.