Conditional Formatting Help

[breely2021]

Hi, 

I am want to fill a cell green if the word in the cell in found in a column.

For example: the word is in cell L5 and I want to search the cells C5 - C80. If the word in L5 appears in C5-C80, I want L5 to turn green.

Is this possible?

If so, can it then be filled down so L6 can then be searched in cells C5 - C80?

Thanks in advance for your help.

[#2 · Accepted solution]

@breely2021 

Select all the cells that you want to format, for example L5:L20

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=ISNUMBER(MATCH(L5,$C$5:$C$80,0))

Click Format...

Activate the Fill tab.

Select green.

Click OK, then click OK again.

[#3]

@Hans Vogelaar Thank you so much. This is exactly what I am after.