Hi Niniel:

Note that using Cells(i,1) restricts the testing to column A because 1 means
column A.
--
Gary''s Student - gsnu200753


"Niniel" wrote:

Thank you, Gary.

I didn't see your how your code was only checking column A, so I went with
Joel's. But I did update his code with your "EntireRow.Interior.ColorIndex".
:)

So that works great now.
Giving row 2 special treatment would be even better (see my previous post),
but I could live with this as is.