KyleJackMorrison
Board Regular
- Joined
- Dec 3, 2013
- Messages
- 107
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Hello,
I would like some sort of data validation, or vba code to stop people entering the wrong information.
I have a list of words which gets coloured in conditional formatting. Sometimes people put in the wrong words. For instance i have the word "Holiday" in conditional formatting turn red. So this would allowed "Easter - Holiday" "Holiday - Easter" any of those. I would like a sort of data validation to do that same to allow set words which are contained in a string.
Words:
".... Holiday"
".... Course"
".... Training"
TIA
I would like some sort of data validation, or vba code to stop people entering the wrong information.
I have a list of words which gets coloured in conditional formatting. Sometimes people put in the wrong words. For instance i have the word "Holiday" in conditional formatting turn red. So this would allowed "Easter - Holiday" "Holiday - Easter" any of those. I would like a sort of data validation to do that same to allow set words which are contained in a string.
Words:
".... Holiday"
".... Course"
".... Training"
TIA