Display a message on a cell and not a comment
Data validation in Excel is very powerful and very useful for helping users work with data in cells or ranges of cells. Instead of putting a comment on a cell (which pops up even if you are not working on that cell), consider using a message feature instead!
When on the cell you want the message to display with:
- Click the Data tab
- In the Data Tools group, select the Data Validation tool
- Select the 'Input Message' tab
- Enable 'Show input message when cell is selected'
- Give your message a title (optional) and text