Hi
I am trying to write a macro code where i have two columns namely BU and CD. In column CE i want the difference of cell CD and BU. i.e.,
CE4= CD4- BU4
CE5 = CD5 - BU5 and so on.. Till the last used row of both the columns which has equal range.
I also want to highlight the rows in which value of CE is either Greater than 0 or less than 0 or N/A.
Thanks in advance.
I am trying to write a macro code where i have two columns namely BU and CD. In column CE i want the difference of cell CD and BU. i.e.,
CE4= CD4- BU4
CE5 = CD5 - BU5 and so on.. Till the last used row of both the columns which has equal range.
I also want to highlight the rows in which value of CE is either Greater than 0 or less than 0 or N/A.
Thanks in advance.