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

Range("C2:C" & Cells(Rows.Count, 2).End(xlUp).Row).Formula = "=IF(C2="""" Then Selection.Interior.ColorIndex = vbBlack)"
am i far off the mark with this..fairly new to VBA, any help appreciated

thank you