Multiple Worksheet_Change macros - How to edit exisiting code to allow for multiple

Hello a few years back I got some help to write a bit of code which would grey out a selection of cells depending on what was input to one particular cell. For the previous use the document worked perfectly but I am now looking to be able to have this feature in 3 separate places within the worksheet. They would need to work independently of each other, as in:

Cell A1 says "Yes" grey out A3, otherwise grey out A4

Cell A5 says "Positive" grey out A9, otherwise grey out A12

Cell A14 says "correct" grey out A20, otherwise grey out A16

The code current looks like this:

Please Login or Register  to view this content.

Any help would be appreciated as I am feeling very out of my depth.

Originally Posted by Richard Buttrey

Is it vital that you use a macro?
It seems to me that standard conditional formatting would achieve what you want.

I’ll be honest I had help creating this so many years back, but that does sound like something that was discussed. The worksheet is a form that I use in the office. I have the worksheet protected, the majority of cells are locked to prevent other people editing it and I also have a button to reset all contents of the sheet back to default. I’m not sure if because of any of this it was decided to do everything in macro format rather than conditional formatting.