Thanks again Don.
I have had a practice with the code you posted, but I've realised that it's
not covering what I'm trying to achieve, and because I haven't the first idea
regarding code language I can't make any adjustments - I can't even make a
colour change as I don't know what colourindex relates to which colour.
You mentioned adding blocks, but I'm afraid I don't know what sections
constitute a block.
Also, perhaps more pertinant than me not understanding the code; the data
will be entered into the cells of a row, and there are likely to be 30 or 40
rows per sheet per week. Using the code, would I need to identify each row
individually within the code?
One last thing, when I enter the code and return to view the spreadsheet it
remains unformatted until I have entered and then deleted data in the range.
When I use this 'live' I will be opening the template spreadsheet (with the
code already in it) then pasting in data from a data registry. Having
practiced this, the spreadsheet remains unformatted unless I delete
something. Agian, having never used code before I don't know how to make the
formatting active from the outset (i.e, the range is red as soon as I open
the template, and remains red until / unless data is pasted in). I'm grateful
for the time you have spent on this Don, but am not sure that a code route is
for me, as I am so out of my depth I don't even know what questions to ask to
help myself, and I can't keep relying on guys like you to take the time to
reply to each little niggle that crops up as I go along. I was hoping that
there would be a quick CF formula that I could enter into a cell then drag
along the cells I want affected, followed by a double click on the bottom rt
corner to send the formula all the way down the columns - I may just be out
of luck!
Thanks again.
Simon.