Howdy,
I'm building a massive financial spreadsheet and need a way to basically create a guide to filling it out. I was hoping to have the cells that require user input to display words or numbers telling people what needs to go there. Example: Birthday, Name, Hours Worked, etc. So I basically want the cell to display these words in like a greyed out format without including them in final calculation until the user manually types over them, but then if the user deletes what they manually input I want the cell to revert to displaying its greyed out original information. If even more possible, I'd like some of these greyed out values to even be the result of some formulas to where they represent projected values and what the user is inputting is the actual value instead of having to have a separate cell for this. I realize that I cold just use comments for some of this, but I'd prefer not to have dozens of comments everywhere and I think this would look/function cleaner if possible.
Any help would be appreciated.
Thanks in advance.
Bookmarks