I'm trying to do conditional formatting based on a VLOOKUP formula, when I plug this formula into a cell I get a TRUE value so I know the formula works correctly but when I try to use it as a conditional formatting rule it fails.
=VLOOKUP([@Number],'[Change Control Status_SHP.xlsx]1-23-2017'!$A$1:$A$1000,1,FALSE)=[@Number]
Excel returns an alert saying that the number I'm using is not valid, any ideas?
Bookmarks