Need to highligh the column if thevalues are not present.

Hi,
I need to write a macro to high light the column.

My scenario is i have a excel with two tabs, project and allocation.In allocation tab i need to highlight the values of project(column) if those values are not present in project tab project column.
if a project is defined in ‘Allocations’ but not in Left column of the ‘Projects ‘ tab then highlight that project in ‘allocations’ tab.

I am newbie to macros so please help how to write the macros.Attached sample sheet.

Thanks in advance

I need this functionality in macros because in my original sheet to add projects i need to insert rows and this functionality should be implemented on newly added rows(should be done without dragging the formula to all cells).

This sheet will be updated by others too so thats the reason i was looking for macro rather than explaining the other guys.
Any ways thanks for responding and can you explain in detail how to achieve this through CF.

Thanks in advance

Thank you!!!!!