If formula i think?
 

Hi,
I have a chart and in it at the end i want a cell to say complete or not
complete depending on answers in previous cells, for example
Processes to do date due checked wi complete complete?
returns 15-Dec Y N complete
Picking 15-Dec Y Y not complete
So word returns is A2 15Dec is B2 so on to complete or non complete in E2 an
so on down so all i enter is Y or N in checked and wi complete boxes and
words complete or not complete enter themselves. Also if there is something
funky with the colour of the box or text even better,
Please help ta,
Steve.