I need a program that will count the number of times a number in a row exceeds or is less than a certain value. The numbers in the target column are DDE linked and will be constantly changing. I need to be able to count every time the value in the target column exceeds or is less than a specified value in the adjacent column. For example, if the number in column A exceeds the number in Column B, Column C will display a "1". If the number in column A changes and goes below the number in column B, then column D will display a 1 and Column C will still display a 1. If the number in column A goes back above the value in column B, then Column C will display a 2 and column D will display a 1 and so forth. Furthermore, I will need to run this program for two sets of cells, ABCD and EFGH. Thank you and let me know if you have any questions.