Hi
could anyone direct me, how I could assign a value to a cell based on the color of another cell? let say I would like cell B2 have value of 1 if Cell A2 is filled with blue color; otherwise, B2 to be assigned 0.
Regards
Maryam
could anyone direct me, how I could assign a value to a cell based on the color of another cell? let say I would like cell B2 have value of 1 if Cell A2 is filled with blue color; otherwise, B2 to be assigned 0.
Regards
Maryam
Last edited: