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

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

Highlighted
Thank you for your answer Sergei!
Related Conversations
Engineering Notation Formatting Excel
Stuart Currie in Excel on
0 Replies
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Set Default to Copy and Paste Visible Cells Only
Karen Arigo in Excel on
2 Replies