Quote Originally Posted by ChemistB View Post
If you attach your workbook (Go advanced> Manage attachments) we can troubleshoot your problem
Hi all,

Thanks for the tips. However it's still not completely working 100% right like the way it's supposed to. I have attached my workbook but changed the abbreviations for confidentiality purposes. As you guys can see, I have identified the abbreviation "SY" in my sheet as to color green. But in my main sheet, I typed SY in column DC and nothing happened. Furthermore, as you can see, there are random blank cells that became colored green.

Thanks!
Maven

sample.xlsx