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