Conditional formatting not working on whole selected range

bravocharlie92

New Member
Joined
Jan 2, 2015
Messages
4
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
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
Office Version
365
Platform
Windows
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))
 

Watch MrExcel Video

Forum statistics

Threads
1,102,369
Messages
5,486,449
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top