Conditional Formatting to Use a formula to determine which cells to format

Hi,

I'm trying to use conditional formatting to apply a rule to determine which cells to format based on data in a cell.

I have attached a sheet of data that includes the data that would determine which cells are to be formatted, this is column A.

When any of the data is entered from column A, the corresponding columns show which headers needed to shown.

Is there a general rule i can use for this or does it need to be seperate for each different data

Any help would be greatly appreciated