Reply to thread

Message: [QUOTE="tech1NJ, post: 3862113"] Tried that. I does not work as Sheet2 E3 is part of the text that is found in the cells in Sheet1 C2:C15000. This almost would need to have a formula that would first see the free text entered in Sheet2 E3, perform the search in Sheet1 C2:C15000, then perform the conditional formating to be yellow. Do you agree.... See example below of what I have. Sheet1 C2:C4 - shorten the number of cells for the example sake C2= Has the build up to date C3 = The build can be out of range C4= All up to date nothing else to do at this time Sheet2 E3 - free text entered by user is "build" (without the quotes). I need Excel to search C2:C4 find the ones with "build: and perform the conditional formatting to equal yellow. [/QUOTE]