[snip]

Thanks! *I'll report back. *:oD

[snip]

Hi! Thanks again for the above! I've been working in the workbook
all day and it's working very, very well so far. I had the
opportunity to add new rows and had to delete a few entries so had
quite a few opportunities to see code in action. I added this to the
add and delete rows macro in the workbook and it adjusts the row
colours after each operation. So, so far, so good.

1. I have one challenge that I can't figure out, which was literally
and figuratively highlighted by using vbYellow. I have the
conditional formatting on column A as well, specifically starting at
A3. This code starts at B3 and through the print area. What do I
need to change to get the row colouring to include column beginning
with A3?

2. Just as an aside, I was able to change the colour from vbYellow,
which is a medium yellow, to the light yellow I always use. The
colour choice line now reads like this:

..FormatConditions(1).Interior.Color = RGB(255, 255, 204)

I don't know what the colour choice is in terms of using a similar
format as "vbYellow" as is in the original code, but fortunately, the
archives via google provided the above option of using RGB values. So
I took a screenshot of a cell with my colour choice and found the that
255, 255 and 204 did the job.

Is there perhaps a guide somewhere on what the Excel colours are
called in the VBE, i.e., like "vbYellow" and "vbRed"? I searched via
google for something that might list the colours but nothing came up
even though I made many search attempts.

Thanks! :oD