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

What are the rules on City and zip? Is there a list of values for state?

Either way, Data Validation ism probably what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"rmeffert " wrote in message
...
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 I
would like to do for my companies spreadsheets.
We have lets say 3 columns - (city, state, zip). I would like to create
a button that called <Validate that a user can click to ensure that
the data entered matches the validations in the cells. And if it
doesnt, I want the macro to highlight the cell that does not conform to
the validation in red. I have seen this done before, I was hoping
someone could assist.


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


Thank you so much ahead of time!


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