Hi, I have a spreadsheet and in column W the cells contain a formula to show if a completion date has not been met:
Code:
=IF(V88>N88,"On Target","Critical completion date has been missed!")
I would like a message box to appear reading "Critical completion date has been missed!"if any of the cells in column W contain "Critical completion date has been missed!"
Any ideas???