Hi, I am trying to use a conditional to get a value from another cell. i.e.

A1 background color is yellow. in B1 I would write something like
if(A1=yellow,1,0) to get a value 1 in the cell B1, or 2 for blue, etc...

Thank you for your help.