Oct 14 2021 03:07 AM
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.
Oct 14 2021 03:50 AM
SolutionSelect 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.
Oct 14 2021 08:09 PM
@Hans Vogelaar Thank you so much. This is exactly what I am after.
Oct 14 2021 03:50 AM
SolutionSelect 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.