Hi Guys

please bear with me as im new to this site.

I have a worksheet that I need a little help with. I want to change the colour of a range of cells, when i enter "P" in a certain cell, but its only changing the cell with P in?

Also I have 52 sections/weeks (6x8 cell per section) to the spreadsheet and wanna protect every cell but a cpl of cells per section.


I can send you the file for you to play with.