Re: I need a little sub routine

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <hshayhorn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F9DE5A54-AEFF-46B7-8E4D-924EA68B2C92@xxxxxxxxxxxxxxxx
OK, let me see if I can clarify this better. I was worried it wouldn't be
very clear.
I have a *** 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" <hshayhorn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2DBFD62D-6859-4D08-8616-F00D038F0C15@xxxxxxxxxxxxxxxx
>I have a work*** 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.



.

Quantcast