I have a cell that has a cell validation. So, if i click on the cell, it brings up a list. Works great. I have data that gets copied into the cell then I can use the data validation to change the units. The problem is some cells are not units so I dont want the user to be able to click on and pick from the list.

Anyway I can alert the user that if the original data in that cell does not match what is in the list then DO NOT use the data validation list to change it.