Use this Custom Function
http://www.ozgrid.com/VBA/ReturnCellColor.htm



--
Regards
Dave Hawley
www.ozgrid.com
"MrBill" wrote in message
...
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