Hmm..i see. I dunno why i keep getting these errors when i insert the macros. Maybe it is smth with my excel.
1. Do not confuse Macros with Formulas ... In this particular case, you are dealing with Conditional Formatting ... so you are using Formulas ...
2. What is smth ...???
3. Will add the Formula to your latest test file ...