Quick Excel question

[Diddums x]

Morning

Quick one for you Excel gurus, I am making a form for my engineers to fill in, many of the answers are simply yes or no so I would like to have boxes with "Yes" and "No" faintly visible in the background so they know which one to tick.

I've tried by simply using a grey font, but it just comes out the same as the rest.

Any ideas?


Cheers

 

[Diddums x]

Because it's a document which will be filled in with pen manually.

Fantastic suggestion though, I completely forgot about dropdown boxes.


**Thinks of ways to use dropdown boxes to have a play**

 

[Diddums x]

Worked a treat, thanks guys