Greetings all,
I'm looking for assistance in auto-populating a function in column B using Conditional Formatting (CF) as new rows of data are entered into Column A.
The current solution in place is: when data is entered into column A, I have to pull/drag/copy down the function from the last cell of functions above in column B down to the last row of data entered from column A (usually accomplished by double-clicking the little box in the bottom right hand corner of the cell outline).
A solution I thought of using is an IF statement for column B in which the cells would appear blank until data is entered into column A. This works like a charm but I was hoping there was a way I could include the function into CF and then when data is entered into rows of column A, the formula in rows of column B would automagically populate.
The problem I'm running into is relative cell reference. I don't know how to reference individual current cells in the function for only when the adjacent cell receives data (in column A).
In the diagram below, the hyperlink which appears in cell B1 is the result of a direct function in that cell. The goal is for that function to fire off when data appears in column A but only for the rows that actually contain data.
Is this possible?
Thanks!
-C
I'm looking for assistance in auto-populating a function in column B using Conditional Formatting (CF) as new rows of data are entered into Column A.
The current solution in place is: when data is entered into column A, I have to pull/drag/copy down the function from the last cell of functions above in column B down to the last row of data entered from column A (usually accomplished by double-clicking the little box in the bottom right hand corner of the cell outline).
A solution I thought of using is an IF statement for column B in which the cells would appear blank until data is entered into column A. This works like a charm but I was hoping there was a way I could include the function into CF and then when data is entered into rows of column A, the formula in rows of column B would automagically populate.
The problem I'm running into is relative cell reference. I don't know how to reference individual current cells in the function for only when the adjacent cell receives data (in column A).
In the diagram below, the hyperlink which appears in cell B1 is the result of a direct function in that cell. The goal is for that function to fire off when data appears in column A but only for the rows that actually contain data.
Is this possible?
Thanks!
-C
Excel 2013 32 bit | ||||
---|---|---|---|---|
A | B | |||
1 | 6121652637168 | 6121652-637168 | ||
2 | 6141653579692 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =HYPERLINK("https://www.abc.com/account/order/"&A1,TEXT(A1,"0000000-000000")) |
Last edited: