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

Highlighted

@rdwyer , it's enough

=A1=TODAY()
Related Conversations
Excel taking forever to launch and very slow
pjvilloud in Excel on
2 Replies
Present Value using the PMT Function
redblasko in Excel on
0 Replies
How to get new column in excel data connection
Adeboy2K in Excel on
1 Replies
Request is invalid?
Thriftman in Excel on
0 Replies
Drop down list on ipad
Skippy95 in Excel on
0 Replies
[SOLVED]Using another sheet like function
Phobosd in Excel on
4 Replies