ExcelBanter - Event Change Copy

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Event Change Copy (https://www.excelbanter.com/excel-programming/360615-event-change-copy.html)

Chuck H.[_2_]

Event Change Copy

Need help!!!!

Let us say everytime I enter "YES" in column B in the same row I want to
insert the following formula:
=IF(B4="Yes",C4&E4,"") and highlith it in green.

How can I do it?
Chuck

Chuck H.[_3_]

Event Change Copy

Sorry! But I missed to say that I need to insert that formula in the
corresponding row but column A.

"Chuck H." wrote:

Need help!!!!

Let us say everytime I enter "YES" in column B in the same row I want to
insert the following formula:
=IF(B4="Yes",C4&E4,"") and highlith it in green.

How can I do it?
Chuck

All times are GMT +1. The time now is 02:55 PM.