I have a worksheet in which in Column A(n) I want to insert automatically a
formula depending on whether one enter in column B(n) a "Y" or a "y". This
formula in Column A will contain: =IF(B(n)="Y", C(n)&E(n)) then highlight in
green the column A(n). Can this be done?

Appreciate your help.