gwoolley0302
Board Regular
- Joined
- May 13, 2014
- Messages
- 57
Hi all,
We share an excel template with our network for them to input quarterly monitoring data with us. Some fields we attempt to restrict through drop down lists. These often get overwritten.
So my question is whether we can use a tool to show the user that they've overwritten a dropdown list cell? (without a macro)
I thought maybe conditional formatting could highlight the cell in red if they overwrite the dropdown list?
We also get a similar issue when data is not entered in the format we would ideally like. Again I wonder if we can use a tool to prompt the user that the cell is incorrect (i.e. a red cell indicates it's been inputted incorrectly)
Thanks, Greg
We share an excel template with our network for them to input quarterly monitoring data with us. Some fields we attempt to restrict through drop down lists. These often get overwritten.
So my question is whether we can use a tool to show the user that they've overwritten a dropdown list cell? (without a macro)
I thought maybe conditional formatting could highlight the cell in red if they overwrite the dropdown list?
We also get a similar issue when data is not entered in the format we would ideally like. Again I wonder if we can use a tool to prompt the user that the cell is incorrect (i.e. a red cell indicates it's been inputted incorrectly)
Thanks, Greg