I want to change the value in a specific cell according to cell color from a different column.
Data table
Counting table
I want to check every cell in column XXX, and if the color is red/green/yellow, add +1 to the counting table in the correct cell. and repeat it for columns YYY and ZZZ
Thanks a lot
try01
this is what I tried just to check if I’m on the right way but no luck so far.
New contributor
dror tirosh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.