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.

=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.

Thanks JMB! it works fine but how would I highlight the cell if the condition
is True?
Is There a way to do that?
I tried the following but it is not working:
In the Conditional Formatting
=IF($B$9="Y","","") turn the color to green.

Thank again for your help!
Chuck
"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.

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.

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.