Forum Discussion
Solved
Conditional Formatting Help
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...
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.
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.
HansVogelaar Thank you so much. This is exactly what I am after.
