I have 2 sheets. Sheet1 & Sheet2.
Sheet 1 has a list of items with descriptions & specific numbers. Sheet 2 has a table filled with the same items.
What I am wanting to do, is highlight a selected cell in Sheet2 if a specific word is mentioned ANYWHERE in Sheet1 using conditional formatting.
For example, if my Sheet2 is a table of numbers 1-12 (Jan-Dec) 1 2 3 4 5 6 7 8 9 10 11 12
And I have a list of dates in Sheet1 column C ex.
January 1, 20xx February 10, 20xx January 20, 20xx December 18, 20xx July 10, 20xx March 5, 20xx September 9, 20xx
In Sheet2, I want the "1" cell highlighted if the word "January" is found ANYWHERE in Sheet1 (specifically in column C, but if there is a command for the whole sheet that would be useful as well). As long as it appears ONCE, I want the cell with "1" highlighted. And so on.
I have gotten a formula to where I can highlight the cell "1" in Sheet2 if I point it to only ONE cell
but I can't figure out how to make it search the entire page, a certain range, or even just that column. I have tried adjusting the C5 to C5:C13, C:C, A1:C9, $C$5, and so many other combinations. I just want it to comb a specific range and highlight my cell as long as the word is found even once.