Forum Discussion
Updating cell values from one cell based on another cell's data
Hello. I would like Excel enter data from one cell into another cell, based on another cell's entry. For example, I have a date in column A, in column B, there will either be a date entered, or n/a. If column B is n/a, then I would like Excel to take the date in column A and enter it into column C. If column B is a date, then I want to enter data into Column C myself. Is this possible?
Sue_G try something like
=IF(ISNUMBER(B1),"enter date",A1)when you click on C1 to "enter date" as instructed it will overwrite the formula there.
That said, not the best practice.
I would recommend making D1
=IF(ISNUMBER(B1),C1,A1)and then use custom formatting to highlight cells in col C that need a date entered
highlight col C and go to custom formatting -> custom formula and enter: =ISNUMBER(B1)
you may also want to lock or maybe gray col D so you/others don't overwrite the formula there.
4 Replies
Sue_G try something like
=IF(ISNUMBER(B1),"enter date",A1)when you click on C1 to "enter date" as instructed it will overwrite the formula there.
That said, not the best practice.
I would recommend making D1
=IF(ISNUMBER(B1),C1,A1)and then use custom formatting to highlight cells in col C that need a date entered
highlight col C and go to custom formatting -> custom formula and enter: =ISNUMBER(B1)
you may also want to lock or maybe gray col D so you/others don't overwrite the formula there.
