Is there a way to test the color of a cell, thought had seen that before but
cannot find. eg: IF(A1=red,1,0)

thanks