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.