Home

Dynamic time axel in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-415056%22%20slang%3D%22en-US%22%3EDynamic%20time%20axel%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-415056%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20create%20a%20time%20function%20that%20is%20highlighting%20the%20actual%20column%20by%20actual%20date%3F%20In%20other%20words%20I%20would%20like%20the%20highlight%20to%20move%20to%20the%20next%20column%20each%20day%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-415056%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-418231%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20time%20axel%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-418231%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F317228%22%20target%3D%22_blank%22%3E%40lennart_exergi1%3C%2FA%3E%26nbsp%3BConditional%20Format%20%26gt%3B%20Use%20a%20formula%20to%20determine%20which%20cells%20to%20format%20%26gt%3B%3C%2FP%3E%3CP%3E%3DIF(A1%20%3D%20TODAY())%3C%2FP%3E%3CP%3EA1%20would%20contain%20the%20date%20%3D%20each%20column%20would%20have%20similar%20conditional%20formatting.%26nbsp%3B%20Choose%20the%20formatting%20of%20your%20choice%20and%20apply%20to%20the%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-418350%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20time%20axel%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-418350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313753%22%20target%3D%22_blank%22%3E%40rdwyer%3C%2FA%3E%26nbsp%3B%2C%20it's%20enough%3C%2FP%3E%0A%3CPRE%3E%3DA1%3DTODAY()%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
lennart_exergi1
Occasional Visitor

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()
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies