Unconditional formatting not colouring the cells and not copying across

[shah]

Hope everyone is well.

Have a problem that I need help on.

On Cell D339 for example: I have a list of subjects and when I select them, they change colour and the 11 cells below: However I'm sure there is a easy way of doing this.
=$D$339="Drama"

How can I change the formulae so it is easy to copy across to the other cells and the ones below, instead of manually doing this?

Attached image

Please help

 

[Macropod]

How about reading the rules you agreed to abide by on each forum when you joined! Then you'll know what is expected.

 

[shah]

I dnt understand, I am asking for help, am I braking rule?

 

[Macropod]

Read the rules...

 

[Fluff]

@shah
While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.