Change a cell's background color based on text content of multiple other cells

0
votes

I want that, if an Excel cell A1 contains text/name that is already inputted into cells F1 through F20, the cell A1 background color should change. Example:

If I enter John Smith in cell A1 and the name John Smith is contained in cell F1, I need cell A1 automatically to change to bright red background color. This also needs to work if the name is entered in, say, cell F5.

1
excelexcel-formulamatchworksheet-functionconditional-formatting
Welcome to Stack Overflow! What have you done so far to solve the issue and why did that not work? – Simon
One solution would be use a COUNTIF formula within Conditional Formatting. see Use a formula to apply conditional formatting for more complete information. – user4039065

1 Answers

0
votes

Please select A1, HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true:: 

=MATCH(A1,F$1:F$20,0)

Format..., select red fill, OK, OK.