Conditional format FALSE

[mcvideo]

I trust the example (pic) is self explanatory in what I am trying to accomplish. I want this same rule applied but for a FALSE format value using this conditional format rule. Hope this make sense. Thanks in advance for your help.

[6StringJazzer]

Sorry, but "FALSE format value" does not mean anything to me. Those three words don't really mean anything strung together. And images are usually not helpful; it would be better to attach your file.

The rule you are showing tries to match $AZ2 to a value in the named range APRIL_PEN_2016. If it can find it, then the IF function returns 1, otherwise an error will occur and IFERROR will produce the "x" result.

If MATCH returns 0, then IF will return FALSE because there is no FALSE alternative specified, but that can't happen anyway because MATCH can never return 0.

So I understand what your rule does, but I don't understand what else you want to do.

[Khalidngo]

Hi @mcvideo,

If I understood you correctly, you can use this formula for CF:
=ISERROR(MATCH($AZ2,APRIL_PEN_2016,0))

If it doesn't help, upload a sample excel file (as described above) with manually expected output.

Regards,

[bebo021999]

to return 1 if matchs, else "x":

=IFEEROR((MATCH($AZ2,APRIL_PEN_2016,0)>0)+0,"x")

[FDibbins]

Hi, welcome to the forum

Not all members can upload/view picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

having said that, what you need to know about CF is that it ONLY needs TRUE or FALSE (or 1 or 0), so using MATCH will either return a value or a FALSE of no match is found.

the IFERROR(if(match())) is pretty much redundant...CF will never return text. Based on this, you could set up 2 CF rules using the exact same formula, 1 for a "found" and 1 for a "not found". Although a better way to do this may be to give all the cells 1 of those colors, then just use CF to change the color for the opposite rule

[mcvideo]

Hi @mcvideo,

If I understood you correctly, you can use this formula for CF:
=ISERROR(MATCH($AZ2,APRIL_PEN_2016,0))

If it doesn't help, upload a sample excel file (as described above) with manually expected output.

Regards,

Thank you. This worked for me.

[mcvideo]

Thanks to all for the feedback. There were other suggested CF that worked as well but I went the simplest method in my opinion mentioned above. Next time I will submit a file example.

Thanks again.