Hey All,

This may be a really simple question to answer but I can't figure it out so
thought someone might be able to help.

I have inserted a checkbox on one sheet which is linked to a cell on another
sheet. This is fine.

When I check the box it comes up with true and un-checked false as expected.

My question: is there any way to make it say "Complete" for true and
"incomplete" for false?

Also is there anyway to change the cell background colour for each value?

Any ideas anyone?

Please bear in mind that I'm still finding my way around the more complex
functions of excel.

Feel free to drop me an email: