formula/macro to colour blank cell in a range

HI All,

i have macro which pulls information from another excel sheet.

what i am looking to do is check a column for blanks and highlight

i was going to add in the following into my script but having some problems

Please Login or Register  to view this content.

am i far off the mark with this..fairly new to VBA, any help appreciated

thank you

Please Login or Register  to view this content.