I have seen a few approaches here but they tend to call upon value change, and I havent been able to retrofit them to color change
I have two Sheets, and I would like to store the date in 'Sheet2!C3' when the color of 'Sheet1!A1' is uptadet to the color in 'Sheet1!B2'.
One problem that i have run into is that i would like to store only the date of change, and not keep reitarating changing every new day once that the colors match (C3 has no data, i have tried to put and if clause that the value is inputed only if the cell is empty, but I couldn't quite make all of it to work together).
If i have suggested any approach in my comment don't anchor on it, my ideas have failed miserably until now.
(A1,B2,C3 are just ilustrative variables i would need to change for each case)
A1/B2/C3 values after ajdusting would look like (if i havent made myself clear enough):
I have two Sheets, and I would like to store the date in 'Sheet2!C3' when the color of 'Sheet1!A1' is uptadet to the color in 'Sheet1!B2'.
One problem that i have run into is that i would like to store only the date of change, and not keep reitarating changing every new day once that the colors match (C3 has no data, i have tried to put and if clause that the value is inputed only if the cell is empty, but I couldn't quite make all of it to work together).
If i have suggested any approach in my comment don't anchor on it, my ideas have failed miserably until now.
(A1,B2,C3 are just ilustrative variables i would need to change for each case)
A1/B2/C3 values after ajdusting would look like (if i havent made myself clear enough):