Yup, I did that. But take a look at this most current sheet. It's still highlighting random items (blank cells) as well as not highlighting my keyword "SY" in the column DC. I've doublechecked my conditional formatting and it was set up correctly, so was my naming convention. But how come it's still not working correctly 100%? You can check it out here:SAMPLE2.xlsx

Thanks!
Maven