Hi. First post so go easy on me.

I'm trying to add conditional validation to a spreadsheet but not getting very far. I have 4 columns (and a variable number of rows). All the cells in column 1 have a dropdown list consisting of 2 options. If option 'A' is selected, then columns 2 and 3 are mandatory for that row. If option 'B' is selected, column 4 is mandatory for that row.

I would ideally like to at least highlight cells that have failed the validation or maybe display a suitable warning message (although I suspect this could be tricky if the sheet extends to a large number or rows). I'm assuming that I'll need some sort of macro to achieve this but don't really know where to start.

Assuming I can get that done, the spreadsheet will then be used as a template in an SSIS process to populate a spreadsheet with data and rename it. The columns I want to validate will be left blank for user input - which is why they need the validation. The SSIS task is working fine, so adding this validation is the last piece of the puzzle.

Any help you can offer would be much appreciated. Thanks.