Conditional Highlight a range of cells based on one cells value, with a relative reference

Good morning.

I would love some assistance with what i thought would be a fairly simple task, but alas, im not getting it

I have attached a sample sheet. What I am looking to do is conditionally format cells in columns B:E if the cell in column B contains the text "Shift".

I have tried the following as the formula in Conditional formatting, but with no luck :

Please Login or Register  to view this content.

The link below is almost what i am after ... but did not work for me.

http://www.excelforum.com/excel-gene...-one-cell.html

I will have a number of Groups of columns across the page, the example only shows 2 sets.

The example sheet has some cells formatted manually to show how i want them to appear, but with conditional formatting as the data will change week to week, with the "Shift" headings being in different rows.

Thanks in advance

Darren

Hi FDibbins

Thanks for the prompt reply

When I copy this down it is highlighting all cells, not just those adjacent to the cells which have "Shift" in them ?

Darren.

My apologies ....... Chair to Keyboard interface failed !!!! lol

Works a treat ... thank you !!!!

(Insert Skulking off to bury head in the sand here)

Darren