Case < > "Value", but Add "Value2" in the same case.. dude..

[feroguz]

Hi!! Good Morning!

I have a doubt in using the following macro:

Please Login or Register  to view this content.

Works fine in the case <> "PZ".
But I require also add that if you have "MT", leave it valid.

If I add the macro function:

Please Login or Register  to view this content.

But it doesn't work, any ideas?

Thank you!
Best Regards!!

[stnkynts]

Just add it below it. That the great thing about Select/Case

Please Login or Register  to view this content.

[feroguz]

Dear Sr:

If I add this case

Please Login or Register  to view this content.

Highlight the 2 options: "MT" & "PZ", but I need to Highlight Only the different values to "MT" & "PZ"..
Help! :S
thanks again!
Best Regards!!

[Norie]

You can just list the criteria.

Please Login or Register  to view this content.

Mind you, as far as I can see the code is going to colour every cell red as your Cases have the same result.

[feroguz]

Hi Norie:

mm.. maybe I didn't express correctly..

I'm only need to highlight the different values that "MT" and "PZ".
"MT" is one option, and "PZ" is other option, if in my column have different values that this 2 options, highlight the cell in red..

[Norie]

I'm afraid it isn't clear.

Your original code formats cells in column D red if they are "" or not equal to "PZ".

What exactly do you want to add to that?

[TMS]

PZ isn't MT so you'll get red. MT isn't PZ so you'll get red. In fact, anything you put in won't be one or the other, so you'll get red.

Regards, TMS