You're welcome. Thanks for the feedback.

"Chuck H." wrote:

Thanks JMB! I found how to do it through the Conditional Formatting as you
said.

Best regards,

"JMB" wrote:

=IF(EXACT(B(n), "Y"), C(n)&E(n), "")

Also, check out conditional formatting.

"Chuck H." wrote:

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.