Home

Conditional formating extraction and copying

%3CLINGO-SUB%20id%3D%22lingo-sub-744838%22%20slang%3D%22en-US%22%3EConditional%20formating%20extraction%20and%20copying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744838%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20self-taught%20excel-user%20and%20I%20read%20and%20watch%20relevant%20blogposts%2C%20online%20conversations%20and%20youtube-clips%20whenever%20I%20need%20to%20solve%20an%20issue%20or%20create%20something%20in%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20now%20I%20have%20reached%20a%20point%2C%20where%20my%20abilities%20do%20not%20apply.%20I%20am%20searching%20for%20a%20formula%20to%20detect%20whenever%20a%20certain%20word%20appears%20in%20a%20cell%2C%20in%20this%20case%20the%20word%20%22opf%C3%B8lgning%22.%20When%20the%20word%20%22opf%C3%B8lgning%22%20appears%2C%20I%20want%20the%20formula%20to%20write%20another%20specific%20word%2C%20for%20example%20%22equipment%20status%22%2C%20as%20well%20as%20any%20text%20written%20in%20%3CSTRONG%3EBOLD%26nbsp%3B%3C%2FSTRONG%3Ein%20the%20cell%20in%20another%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20my%20description%20makes%20sense%2C%20and%20that%20someone%20can%20help%20me%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%20MKAEIM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-744838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745024%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formating%20extraction%20and%20copying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373372%22%20target%3D%22_blank%22%3E%40MKAEIM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20any%20text%20within%20another%20text%20using%20SEARCH()%20or%20FIND()%2C%20usual%20check%20if%20found%20or%20not%20is%20like%20%3DISNUMBER(SEARCH(...)).%20But%20you%20can't%20check%20with%20formulas%20if%20text%20bold%20or%20not.%20Formulas%20work%20only%20with%20cell%20values%2C%20not%20with%20with%20cell%20properties%20colors%20and%20cells%20formatting.%20You%20need%20VBA%20programming%20for%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-750116%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formating%20extraction%20and%20copying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750116%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20answer%20Sergei!%3C%2FLINGO-BODY%3E
MKAEIM
New Contributor

Hi!

 

I am a self-taught excel-user and I read and watch relevant blogposts, online conversations and youtube-clips whenever I need to solve an issue or create something in excel. 

 

Right now I have reached a point, where my abilities do not apply. I am searching for a formula to detect whenever a certain word appears in a cell, in this case the word "opfølgning". When the word "opfølgning" appears, I want the formula to write another specific word, for example "equipment status", as well as any text written in BOLD in the cell in another cell.

 

I hope my description makes sense, and that someone can help me out. 

 

Best regards MKAEIM

2 Replies

@MKAEIM 

 

You may any text within another text using SEARCH() or FIND(), usual check if found or not is like =ISNUMBER(SEARCH(...)). But you can't check with formulas if text bold or not. Formulas work only with cell values, not with with cell properties colors and cells formatting. You need VBA programming for that.

Thank you for your answer Sergei!
Related Conversations