My problem:
I have a range of cells (C16:C43) on sheet (week3&4).
These cells contain text.
I need code to look up and match text on sheet (employees)(cells B5:B43) and when it finds a match if column D is not blank do nothing but if it is blank turn cell on sheet (week3&4) red.
I tried to do this with conditional formatting but it dosn't allow you to do something from another sheet.
Thanks
Rick
I have a range of cells (C16:C43) on sheet (week3&4).
These cells contain text.
I need code to look up and match text on sheet (employees)(cells B5:B43) and when it finds a match if column D is not blank do nothing but if it is blank turn cell on sheet (week3&4) red.
I tried to do this with conditional formatting but it dosn't allow you to do something from another sheet.
Thanks
Rick