Conditional formatting not working on whole selected range

[bravocharlie92]

Hi,

I am using conditional formatting with the formula =IF(ISERROR(MATCH(Q4,Sheet2!$A:$A,0)),FALSE,TRUE) with range =$Q$4:$Q$2000 but it only works until cell Q216 and doesn't format anything after that.

I have no idea why it's not working, can anyone help?

Thanks

 

[Fluff]

No idea why it stops at Q216, other than maybe there is no match below that.
However you can simplify your formula like
=ISNUMBER(MATCH(Q4,Sheet2!$A:$A,0))