Unconditional formatting not colouring the cells and not copying across

shah

New Member
Joined
Jan 8, 2006
Messages
30
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
 

Attachments

  • spreadsheet.png
    spreadsheet.png
    121.9 KB · Views: 9

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,526
Office Version
  1. 365
Platform
  1. Windows
Just remove the $ signs from the formula.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,526
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Jan 8, 2006
Messages
30

ADVERTISEMENT

How can I email you the spreadsheet?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,526
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,529
Messages
5,625,354
Members
416,096
Latest member
forevans

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top