Forum Discussion
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?
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()