Forum Discussion
kyle haninger
Aug 08, 2018Copper Contributor
Form control = adds blank row below row I'm currently in, conditional formatting and formula.
I hope I explain this correctly C5 = todays date =TODAY() Column M = Has this formula =IF(I2="","",I2-C$5) it calculates the difference in days from a random date(Column I) and it had...
Philip West
Steel Contributor
Could this not be done with a Table (ctrl+t) rather than VBA?
If you have a table with formula and/or conditional formatting in it, when you insert a new row it would inherit those formula and formatting.
kyle haninger
Aug 16, 2018Copper Contributor
Thank you!