Home

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-680121%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680121%22%20slang%3D%22en-US%22%3EHi%2C%20I%20am%20trying%20to%20format%20a%20cell%20to%20change%20text%20first%2030%20days%20prior%20to%20a%20date%20and%20then%20cell%20at%20the%20date%20please%20help%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-680121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681097%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681097%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357406%22%20target%3D%22_blank%22%3E%40Nigel1967%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20provide%20some%20sample%3F%20%22to%20change%20text%22%20you%20mean%20to%20change%20format%20of%20the%20text%20or%20insert%20another%20text%20into%20the%20cell%3F%20Prior%20to%20the%20date%20-%20you%20compare%20TODAY()%20with%20some%20date%20or%20what%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Nigel1967
Occasional Visitor
Hi, I am trying to format a cell to change text first 30 days prior to a date and then cell at the date please help
1 Reply

@Nigel1967 ,

Perhaps you may provide some sample? "to change text" you mean to change format of the text or insert another text into the cell? Prior to the date - you compare TODAY() with some date or what?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies