Hide values contained within cells in worksheet unless value populated in adjacent cell

[JayReddy]

Hi,

Looking for some help please ...

I would like to know how to hide values contained within two cells in an Excel worksheet unless a specific value is populated in an adjacent cell.

For example, I have updated cell A1 with text stating 'Role Required' and in cell A2 I have added a drop-down list with the following values that users will define based on the particular role that they require:

Vendor Approver Role
Vendor Requestor Role

What I would like to do is once a user selects 'Vendor Approver Role' from the drop-down list in cell A2, cells B1 and B2 will then be populated. If 'Vendor Approver Role' is not selected then the values within cells B1 and B2 should remain hidden.

When 'Vendor Approver Role' is selected, cell B1 will contain text stating 'Approval Level' and cell B2 will contain a drop-down list with the following values:

1st Level Approval
2nd Level Approval
3rd Level Approval

Thanks in advance,

Jay