Alison,

This may sound a little silly, but can't you use another cell to say that it
is complete or turn off data validation for that cell?

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Alison84" wrote:

Hi,

I am trying to write a formula that will return the word Complete in cell A1
if there is any value in cell C1.

I can do this with this formula =if(not(isblank(c1)), "Complete", "")

But... column A has data validation so I can't write the formula in. When I
write this formula in the conditional formatting formula is box it doesn't
accept it.

Can anyone help??

Thanks :)