Thread: [Solved] Problem with Conditional Formatting
View Single Post
 
Old 03-24-2012, 08:16 PM
MarvinP MarvinP is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jan 2012
Location: Seattle, WA
Posts: 12
MarvinP is on a distinguished road
Default
Hi WRighty50
I'd try making your CF formula a little different.
You have
=ISERROR(MATCH(B2,INDIRECT(SUBSTITUTE(A2," ","")),FALSE))
and I'd try
=ISERROR(MATCH($B2,INDIRECT(SUBSTITUTE($A2," ","")),FALSE))

BTW - Column 3 didn't turn red on your attached.
Reply With Quote