How to quickly insert a line based on current date in Excel?

Supposing there is a sheet containing a row with dates, and now I want to insert a line right to the current date which will auto change while opening the workbook every day. Is there a trick can solve it in Excel?

Insert a current date line

Insert a current date line

Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!

Save 50% of your time, and reduce thousands of mouse clicks for you every day!

To insert a current date line in cell, you can apply the Conditional Formatting function.

1. Select the range you want to insert line, and click Home > Conditional Formatting > New Rule. See screenshot:

2. In the New Formatting Rule dialog, select Use a formula to determine which cells to format, and type this formula =IF(B$1=TODAY(),TRUE, FALSE) to the Format values where this formula is true text box. Click Format to go to the Format Cells dialog, under Border tab, specify the line as you need. See screenshot:

3. Click OK. There is a line auto inserted at the right of the current date cell.

Relative Utility:

Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

• More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
• No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
• Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
• Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
• 110,000 highly effective people and 300+ world-renowned companies' choice.
• 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Read More       Download Now       Purchase

---

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

• Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Read More       Download Now       Purchase