Hi,

I have a pretty large sheet (3000+ rows), whereby if the cell in column A of a row contains a number of between 1 and 150, then I would like the corresponding cell in Column E to be grey with a border around it. Obviously an arduous task if done using Copy & Paste and unfortunately I need this to happen in a number of sheets and don't fancy RSI at the end of the exercise.

As part of a second part of the project, I need to be able to 'Unlock' the cells that end up as grey w/border so that I can protect the sheet and only leave the grey cells as editable.

Hope someone can help!

TJ