If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Simon" wrote in message
...
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.