Dynamic time axel in excel

Copper Contributor

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?

2 Replies

@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.

@rdwyer , it's enough

=A1=TODAY()