Home

How do i get this formula to work using conditional formatting?=IF(ISNUMBER(SEARCH("abc",B5)),B5,"")

%3CLINGO-SUB%20id%3D%22lingo-sub-799220%22%20slang%3D%22en-US%22%3EHow%20do%20i%20get%20this%20formula%20to%20work%20using%20conditional%20formatting%3F%3DIF(ISNUMBER(SEARCH(%22abc%22%2CB5))%2CB5%2C%22%22)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799220%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20scheduling%20spreadsheet%20on%20excel.%20In%20each%20column%20there%20will%20be%20a%20Workers%20name%20and%20in%20each%20row%20their%20will%20be%20time%20slots%20in%2030%20min%20increments.%20The%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CSPAN%20class%3D%22sy1%22%3E%3D%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-if-function%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22kw2%22%3EIF%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22sy0%22%3E(%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-isnumber-function%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22kw3%22%3EISNUMBER%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22sy0%22%3E(%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-search-function%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22kw4%22%3ESEARCH%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20class%3D%22sy0%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22st0%22%3E%22abc%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22sy0%22%3E%2C%3C%2FSPAN%3EB5%3CSPAN%20class%3D%22sy0%22%3E))%2C%3C%2FSPAN%3EB5%3CSPAN%20class%3D%22sy0%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22st0%22%3E%22%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22sy0%22%3E)%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3EThis%20works%20when%20i%20want%20to%20pair%20two%20employees%20together%20and%20have%20both%20cells%20relay%20the%20same%20information.%20The%20problem%20is%20i%20ONLY%20want%20this%20formula%20to%20work%20when%20it's%20triggered%20by%20the%20other%20cells%20text.%20In%20other%20words%2C%20i%20need%20the%20same%20effect%20still%2C%20however%2C%20i%20need%20it%20to%20work%20within%20conditional%20formatting%20so%20that%20i%20may%20still%20use%20each%20cell%20for%20adding%20work%20descriptions%20to%20the%20cell%20if%20they%20are%20not%20paired.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-799220%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
Highlighted
Ranks360
Occasional Visitor

I am trying to create a scheduling spreadsheet on excel. In each column there will be a Workers name and in each row their will be time slots in 30 min increments. The formula:

 

=IF(ISNUMBER(SEARCH("abc",B5)),B5,"")

This works when i want to pair two employees together and have both cells relay the same information. The problem is i ONLY want this formula to work when it's triggered by the other cells text. In other words, i need the same effect still, however, i need it to work within conditional formatting so that i may still use each cell for adding work descriptions to the cell if they are not paired.  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies