Turn Cell Color depending on Word

I checked your sample.xlsx and you have Conditional Formatting Rules all over your sheet that apply to all kind of random cells.

Best advice is to clear your whole sheet of Conditional Formats and start fresh.

To clear all your sheets of all Conditional Formatting,
On the Ribbon, Select Home Tab,
Select Conditional Formatting,
Select Clear Rules
Select Clear Rules from Entire Sheet

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