Advanced Conditional Formatting and Changing Cell Colours

[gregglazar]

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!

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[gregglazar]

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

Gord Dibben MS Excel MVP







- 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

 

[Gord Dibben]

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

 

[gregglazar]

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




- 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

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

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




- 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