jongooligan
Board Regular
- Joined
- Jul 23, 2007
- Messages
- 90
Got data validation in an input sheet that is based on a list. Turned off the error alert because the users need to sometimes enter values that are not on the list. We need to capture these values and maybe add them to the list if they occur frequently enough.
Is there a way of conditionally formatting these cells based on whether they appear in the list. Must be a non coding solution as this sheet will not be supported when I clear off (which will be soon).
Is there a way of conditionally formatting these cells based on whether they appear in the list. Must be a non coding solution as this sheet will not be supported when I clear off (which will be soon).