insert text into cell as instructions but won't be used in calculations

[gryffin13]

I have created a spreadsheet with lots of data. Most of the cells have formulas to calculate their value that are dependent on other cells. there are a certain number of cells that require the end users to input data in order for the rest of the cells to fill. Is there any way that I could insert text into these cells (they might be red text that says "insert your data here") so that the user would easily recognize where they are supposed to enter the data, but wasn't actually writing in the cell? Because if I just type in the cell, then all of the other cells have errors because they are using text in calculations. I know that as soon as the text is replaced it would work, but that does not work for me. Does anyone know of any way to do this? thanks.

[JBeaucaire]

All your OTHER formulas that reference the "temp text" cell would have to be rewritten to NOT calculate.

For instance, assuming a note might be in A1, a formula in B1 that looks like this:

=A1 * 4.5

...would have to change to:

=IF(ISTEXT(A1), "", A1 * 4.5)