Hi - wondered if anyone could help?

I have a template that multiple members of our team are going to fill in and save but I wanted to make sure all the necessary cells are filled in. Basically I need cells C4:C6 and F4:F6 to be mandatory at all times and on rows 9 to 13, if column B is filled in then columns C, D & E must also be filled in. i.e If B9 if populated then C9:E9 must be mandatory.

I have attached the sheet I am working on if it helps. Apologies if this has been covered in a previous thread but I had a look through and any coding I found did not work when I copied it into VBA.

Many thanks.

Missed RI Checker.xlsm