Forum Discussion

lennart_exergi1's avatar
lennart_exergi1
Copper Contributor
Apr 09, 2019

Dynamic time axel in excel

Is it possible to create a time function that is highlighting the actual column by actual date? In other words I would like the highlight to move to the next column each day?

Formulas and Functions

2 Replies

  • rdwyer's avatar
    rdwyer
    Copper Contributor
    Apr 09, 2019

    lennart_exergi1 Conditional Format > Use a formula to determine which cells to format >

    =IF(A1 = TODAY())

    A1 would contain the date = each column would have similar conditional formatting.  Choose the formatting of your choice and apply to the column.

Resources