Thanks!

This works perfectly!

The only 3 issues are
1) I'm not familiar enough with macro's yet to be able to understand the coding
2)because of reason 1 I dont know how to adjust this to make it work for the other columns
3) I was hoping more on finding out how to use a formula/function instead of a macro

For anyone reading this:
This Macro DOES WORK!!!
It's just not what i was looking for.