Hi all,
This one can be difficult..
Imagine a blank worksheet with 5 colored cells in Yellow (C1:C5). Those cells have values from 1 to 5. Then I have another cell, lets say F5 that has to look to the range C1:C5.
If I change the color of one of the yellow cells to green, cell F5 has to give the value of the green cell.
There is always only one green cell upon the other yellow cells. But the green cell changes from C1 tot C5 and F5 has always have to give the value of the green one.
Anyone who is smarter then me to create a code for this?
This one can be difficult..
Imagine a blank worksheet with 5 colored cells in Yellow (C1:C5). Those cells have values from 1 to 5. Then I have another cell, lets say F5 that has to look to the range C1:C5.
If I change the color of one of the yellow cells to green, cell F5 has to give the value of the green cell.
There is always only one green cell upon the other yellow cells. But the green cell changes from C1 tot C5 and F5 has always have to give the value of the green one.
Anyone who is smarter then me to create a code for this?