Hello everyone! You guys helped me out of a huge jam a few weeks ago
and I was hoping you could help me out on this less critical add-on
would like to do for my companies spreadsheets.
We have lets say 3 columns - (city, state, zip). I would like to creat
a button that called <Validate that a user can click to ensure tha
the data entered matches the validations in the cells. And if i
doesnt, I want the macro to highlight the cell that does not conform t
the validation in red. I have seen this done before, I was hopin
someone could assist.


Ex: Validation set in state column is 2 chars - however someone type
out the whole state, when this button is pushed it will highlight tha
state in red so the user knows its in error.


Thank you so much ahead of time

--
Message posted from http://www.ExcelForum.com