I have multiple spreadsheets in a single workbook, each of which when completed by the user, will become final documents for review either by priniting or by viewing within excel. Cells requiring user input can be surrounded by auto populated cells based upon the user inputs. I am looking for a way to denote the cells that require user entry. However, I do not want to use a cell highlight as the highlight will appear in the printed final copy. Also thought about conditional formatting, but if the sheets are updated, then the cells will already be populated. I tried placing a comment within in each (with no comment text) as a way to note cells users must fill in. This does not look too bad, but would like to review other options.
Thanks in advance,
Danny
Thanks in advance,
Danny