I have three basic (for programmers) conditional formatting problems
to solve in Excel for which I require some help. These are the last 3
conditions I need to complete for the worksheet so any help will be
really appreciated. They are as follows:

1.
If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell
Z2


2.
If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I
need to change the colour of the cell containing "Z" (V2, W2 or X2).
If changing the colour of only the single cell containing "Z" cannot
be done, I guess changing the colour of the whole row would be okay.


3.
If cell Y2 or cell AA2 > 0 and cell R2 <> 100 I need to change the
colour of the row


Thanks to the google group community in advance!

Might be an idea if you read the replies to your last two postings on the same
subject.


Gord Dibben MS Excel MVP

On 8 Feb 2007 18:40:46 -0800, (E-Mail Removed) wrote:

>I have three basic (for programmers) conditional formatting problems
>to solve in Excel for which I require some help. These are the last 3
>conditions I need to complete for the worksheet so any help will be
>really appreciated. They are as follows:
>
>1.
>If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell
>Z2
>
>
>2.
>If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I
>need to change the colour of the cell containing "Z" (V2, W2 or X2).
>If changing the colour of only the single cell containing "Z" cannot
>be done, I guess changing the colour of the whole row would be okay.
>
>
>3.
>If cell Y2 or cell AA2 > 0 and cell R2 <> 100 I need to change the
>colour of the row
>
>
>Thanks to the google group community in advance!

On Feb 9, 1:58 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> Might be an idea if you read the replies to your last two postings on the same
> subject.
>
> Gord Dibben MS Excel MVP
>
> On 8 Feb 2007 18:40:46 -0800, greggla...@gmail.com wrote:
>
>
>
> >I have three basic (for programmers) conditional formatting problems
> >to solve in Excel for which I require some help. These are the last 3
> >conditions I need to complete for the worksheet so any help will be
> >really appreciated. They are as follows:
>
> >1.
> >If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell
> >Z2
>
> >2.
> >If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I
> >need to change the colour of the cell containing "Z" (V2, W2 or X2).
> >If changing the colour of only the single cell containing "Z" cannot
> >be done, I guess changing the colour of the whole row would be okay.
>
> >3.
> >If cell Y2 or cell AA2 > 0 and cell R2 <> 100 I need to change the
> >colour of the row
>
> >Thanks to the google group community in advance!- Hide quoted text -
>
> - Show quoted text -

Unfortunately the info they contain is not correct. I am posting them
again in attempt to get a response that I can use, but you can be rude
and nasty about it if you like. I guess no one can stop you

If the responses to your other posts did not help, stick(reply)to the threads
you found them in and explain what did or did not work rather than just posting
again in another news group.

That's how things are done in these groups in order to maximize the assistance
you get.

If you consider this to be a rude and nasty reply then I do not apologize.


Gord

On 8 Feb 2007 19:07:25 -0800, (E-Mail Removed) wrote:

>On Feb 9, 1:58 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>> Might be an idea if you read the replies to your last two postings on the same
>> subject.
>>
>> Gord Dibben MS Excel MVP
>>
>> On 8 Feb 2007 18:40:46 -0800, greggla...@gmail.com wrote:
>>
>>
>>
>> >I have three basic (for programmers) conditional formatting problems
>> >to solve in Excel for which I require some help. These are the last 3
>> >conditions I need to complete for the worksheet so any help will be
>> >really appreciated. They are as follows:
>>
>> >1.
>> >If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell
>> >Z2
>>
>> >2.
>> >If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I
>> >need to change the colour of the cell containing "Z" (V2, W2 or X2).
>> >If changing the colour of only the single cell containing "Z" cannot
>> >be done, I guess changing the colour of the whole row would be okay.
>>
>> >3.
>> >If cell Y2 or cell AA2 > 0 and cell R2 <> 100 I need to change the
>> >colour of the row
>>
>> >Thanks to the google group community in advance!- Hide quoted text -
>>
>> - Show quoted text -
>
>Unfortunately the info they contain is not correct. I am posting them
>again in attempt to get a response that I can use, but you can be rude
>and nasty about it if you like. I guess no one can stop you

On Feb 9, 2:17 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> If the responses to your other posts did not help, stick(reply)to the threads
> you found them in and explain what did or did not work rather than just posting
> again in another news group.
>
> That's how things are done in these groups in order to maximize the assistance
> you get.
>
> If you consider this to be a rude and nasty reply then I do not apologize.
>
> Gord
>
> On 8 Feb 2007 19:07:25 -0800, greggla...@gmail.com wrote:
>
>
>
> >On Feb 9, 1:58 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> >> Might be an idea if you read the replies to your last two postings on the same
> >> subject.
>
> >> Gord Dibben MS Excel MVP
>
> >> On 8 Feb 2007 18:40:46 -0800, greggla...@gmail.com wrote:
>
> >> >I have three basic (for programmers) conditional formatting problems
> >> >to solve in Excel for which I require some help. These are the last 3
> >> >conditions I need to complete for the worksheet so any help will be
> >> >really appreciated. They are as follows:
>
> >> >1.
> >> >If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell
> >> >Z2
>
> >> >2.
> >> >If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I
> >> >need to change the colour of the cell containing "Z" (V2, W2 or X2).
> >> >If changing the colour of only the single cell containing "Z" cannot
> >> >be done, I guess changing the colour of the whole row would be okay.
>
> >> >3.
> >> >If cell Y2 or cell AA2 > 0 and cell R2 <> 100 I need to change the
> >> >colour of the row
>
> >> >Thanks to the google group community in advance!- Hide quoted text -
>
> >> - Show quoted text -
>
> >Unfortunately the info they contain is not correct. I am posting them
> >again in attempt to get a response that I can use, but you can be rude
> >and nasty about it if you like. I guess no one can stop you- Hide quoted text -
>
> - Show quoted text -

This wasn't a rude and nasty response at all. Your first one was, and
don't worry I certainly wasn't expecting an apology from your decent
self

Just as flies are attracted to sugar, and not vinegar, helpful suggestions
are attracted by congenial requests and responses, not ones that are
discourteous and/or impertinent.

Such threads are just ignored and left unanswered.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
On Feb 9, 2:17 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> If the responses to your other posts did not help, stick(reply)to the
> threads
> you found them in and explain what did or did not work rather than just
> posting
> again in another news group.
>
> That's how things are done in these groups in order to maximize the
> assistance
> you get.
>
> If you consider this to be a rude and nasty reply then I do not apologize.
>
> Gord
>
> On 8 Feb 2007 19:07:25 -0800, greggla...@gmail.com wrote:
>
>
>
> >On Feb 9, 1:58 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> >> Might be an idea if you read the replies to your last two postings on
> >> the same
> >> subject.
>
> >> Gord Dibben MS Excel MVP
>
> >> On 8 Feb 2007 18:40:46 -0800, greggla...@gmail.com wrote:
>
> >> >I have three basic (for programmers) conditional formatting problems
> >> >to solve in Excel for which I require some help. These are the last 3
> >> >conditions I need to complete for the worksheet so any help will be
> >> >really appreciated. They are as follows:
>
> >> >1.
> >> >If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell
> >> >Z2
>
> >> >2.
> >> >If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I
> >> >need to change the colour of the cell containing "Z" (V2, W2 or X2).
> >> >If changing the colour of only the single cell containing "Z" cannot
> >> >be done, I guess changing the colour of the whole row would be okay.
>
> >> >3.
> >> >If cell Y2 or cell AA2 > 0 and cell R2 <> 100 I need to change the
> >> >colour of the row
>
> >> >Thanks to the google group community in advance!- Hide quoted text -
>
> >> - Show quoted text -
>
> >Unfortunately the info they contain is not correct. I am posting them
> >again in attempt to get a response that I can use, but you can be rude
> >and nasty about it if you like. I guess no one can stop you- Hide quoted
> >text -
>
> - Show quoted text -

This wasn't a rude and nasty response at all. Your first one was, and
don't worry I certainly wasn't expecting an apology from your decent
self