• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problems with Conditional formatting

D

DashboardNovice

Member
Is there anything wrong with this code:

=VLOOKUP($A2,'Raw Data'!$A:$B,2,0)<>"Include"

When I change <> to = it works. So it seems like CF doesn't like the <> sign.
 
DashboardNovice said:
Is there anything wrong with this code:

=VLOOKUP($A2,'Raw Data'!$A:$B,2,0)<>"Include"

When I change <> to = it works. So it seems like CF doesn't like the <> sign.
Click to expand...
Hi,

That will work fine as a conditional format formula. Post a copy of the workbook where it's not working.
 
Hi,

This will do CF when B column on Raw Data Sheet does not contain Include.

So do want CF when you have include or not?

Regards,
 
You must log in or register to reply here.
Back
Top