Adding specific word in one cell, results in cells being filled with a certain colour

[MrAlexN]

Hope someone can help please. When I type a specific word into column B, I would like the result to show by automatically colouring certain cells in dark grey. For example, if I type BED in cell B16, I would like cells D16, E16, G16 i to fill in dark grey. If I cant have a grey cell, an X will be ok but prefer a colour. Many kind thanks

 

[MrAlexN]

You could, but you do realise that you would also have to change every column reference within your code ("AE" for example would have to become "AF" if only one column was added) - is that what you really want?

Ahhh good thought. You can see I am new to this!

I think I will manually have to do one line and then copy/paste that specific range of cells each time I need to

But appreciate everyone’s help and time as it has been valuable knowledge

Thank you all