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

 

[Fluff]

Just remove the $ signs from the formula.

 

[shah]

Tried that and no it doesnt

 

[Fluff]

Very difficult to tell as I cannot see D339 & there are no cells in the range that have Drama.
What exactly are you trying to do?

 

[shah]

How can I email you the spreadsheet?

 

[shah]

How can I email you the spreadsheet?

In the D339 cell i select Drama and the cells below change colour also.

 

[Fluff]

Ok, do you mean you want to format each block based on the value in the top left cell?
If so, then I'm afraid I don't know of any quick & simple way. You could use the format painter, but you would still need to edit the formula.

 

[shah]

Yeahhh think this would take time.

 

[Macropod]

Cross-posted at:
Unconditional formatting not colouring the cells and not copying across (msofficeforums.com)
Change a Celll Value & Automatically Change Colour of Cells Below (excelforum.com)
Conditional formatting help [SOLVED] (excelforum.com)
Please read Mr Excel's policy on Cross-Posting in rule 13: Message Board Rules

 

[shah]

So I cannt ask other forums for help?