Changing cells in range based on a range title

I have a column of 25 triggers that have Y or N and the occasional B (for Blocked) for an execution of an automated script. I have a few different scenarios that I would like to control by setting ranges within the column. For the example lets call the three by; "ALL", "PARTIAL", and "CUSTOM".

1. I WANT ALL CELLS IN THE RANGE B2:B26 TO BE CHANGED TO "Y" IF THE TRIGGER SETTING CELL OF G2 IS "ALL".
2. I WANT A SUBSET OF 10 CELLS IN THE RANGE B2:B26 TO CHANGE TO "Y" IF THE TRIGGER SETTING CELL OF G2 IS "PARTIAL"
3. I WANT A SUBSET OF CELLS IN THE RANGE B2:B26 TO CHANGE TO "Y" IF THE TRIGGER SETTING CELL OF G2 IS "CUSTOM"

I have tried numerous scenarios without luck.

Recent Questions...