How to block a cell depending on the value of another cell

I have a challenge in front of me that I am not able to solve. Any help or documentation is welcome.

I have had to pull up some Excel templates to be able to import data into a CRM. So far so good. The problem is that in the CRM we have implemented a hierarchy using Business Rules that using the Excel templates does not work.

I have been reading about the creation of macros and also about the data validation to find the solution but I am not able to do it because I have no knowledge about Excel.

Here I add a small graphical demonstration of what I am trying to implement, although so far with little success.

Any help, similar examples, documentation or suggestions would be a great help, thank you all very much!

1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Change all the instances of "Table1" to the name of your data table

Please Login or Register  to view this content.

Maybe save a copy as CSV or XLSX and then import that rather than importing the Macro file?

You can use Excel's Save As function to save a copy of your file as any of these formats: .xml .csv .txt .xlsx