Assuming you have a fill color in the cell first try
formatconditional formatformula is=c1<""format to no color

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JD" wrote in message
...
Is it possible to format a spreadsheet to remove the fill color of each
cell
once data has been entered into that cell? How?

Thanks

--
JD