Hello:

I’m hoping the Excel user community can help me with a question. I have a worksheet that contains a drop-down list in Column B. Available values are ATM, CHK, DEP, and EBT. I would like to set up a validation rule that would require the user to enter a value from 0000-9999 in Column C if “CHK” is selected in Column B. How can I do this?

Your feedback and advice are greatly appreciated!

– DM

​Hello: I’m hoping the Excel user community can help me with a question. I have a worksheet that contains a drop-down list in Column B. Available values are ATM, CHK, DEP, and EBT. I would like to set up a validation rule that would require the user to enter a value from 0000-9999 in Column C if “CHK” is selected in Column B. How can I do this? Your feedback and advice are greatly appreciated! – DM  Read More

​