Make a cell look like an input box

[xVikesh]

Hello

I have a spreadsheet with certain cells for a user to input. For example, in a cell the user inputs their age, and in some other cells I used data validation to create drop down boxes for the user to choose an option. However, these age cells do not look like a box for the user to input and the drop down boxes do not look like drop down boxes until the user clicks the cell. I don't want to use the combo box option through the developer vba route because it means creating many macros and removing all the data validation boxes i have already created. Is there a way I can just make a cell look like a box that needs data to be inputted?

Thanks in advance

 

[Snakehips]

xVikesh,

I don't think you have any option other than to rely on standard formatting.
Decide on a style / format that will differentiate between your background /non-input cells and apply that to all of the input cells.

Eg...Excel 2007

	C	D	E
2
3
4	Age:	23
5
6
7

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Edit** The above snapshot does not render as intended.
But e.g. Thick border and contrast cell interior for input cells.
Set background cells white fill or disable gridlines. etc etc.

​

Hope that helps.

 

[xVikesh]

Thank you, I will change the formatting for the cells so they look more like input boxes