I think that what you want to do in logic terms is:
Row=3
If A:Row="BLUE" then
Colour these cells grey : A:Row+2, A:Row+4, A:Row+5,A:Row+7
end if

The trouble is that this logic breaks down for the second example.

I think that activecell.row may be the starting point for some code that is
applicable for many starting points.

HTH

"hshayhorn" wrote:

I have a worksheet that I need to validate and change cells in a row based on
the value of one of the cells within that row. For example. If A3=Blue then
A5, A7, A8 and A10 would be colored GREY. I can handle that but what I'm
having trouble with is I need something that will call that same routine for
A4, A5, A6, A7 and so on... The value in A no matter what the row controls
whether or not the same cells in their respective column is greyed out or
now. I don't want to have to write hundreds of these routines I'm hoping for
just one that will understand that I'm only dealing with the row the user
just ented data in.

I hope that was enough informaiton.