One more question. Is the only color name that will force a change in B1,
D1, G1 and I1's cell shading the word "Purple"? That is, am I correct in
assuming *any* other text (whether the word "Blue" or not) will make it so
there is no cell shading in those cells?

--
Rick (MVP - Excel)


"hshayhorn" wrote in message
...
OK, let me see if I can clarify this better. I was worried it wouldn't be
very clear.
I have a sheet with several columns. Depending on the value in column A of
each row I need to change the color of other cells or columns in that row.
The change in color needs to be for that row only though. So...

Example

If A1 = "Purple" then B1, D1, G1 and I1 the cell shading or color for
those
cells is changed to grey

Now, if A2 = "Blue" then nothing changes

Then if A3 = "Purple" then B3, D3, G3 and I3 the cell shading or color for
those cells is changed to grey.

I hope this is clearer. I did make a mistake in my earlier post. Thanks
for
catching it.


"Rick Rothstein" wrote:

Can you clarify your description? You say if A3=Blue, then make A5, A7,
A8
and A10 grey, but then go on to test A5, A7, etc. for being blue. Did you
mean the A5, A7, A8 and A10 to be columns by any chance (and if yes,
which
ones)?

--
Rick (MVP - Excel)


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