Thanks. Here is the sample file. I will have no control over people entering data in the columns that are not highlighted. There is a danger they may leave a blank cell or use the wrong format. i would like to place a conditional format in column H that would highlight problems like the one at H20 which is caused by a blank cell in column E. It would also check for any other errors that may occur with people copying and pasting cells and possibly knocking out the formulas. This is to give the users an immediate notification to rectify their entry.
I will try the example you have given above.
Thanks
Bookmarks