We usually use Ctrl and F to quickly find the content we need in Excel. There is a function that can also help us to find something by keywords and even filling color to tell from other cells. So, how to auto-fill color in Excel? Let’s check this out.
Here is a full name list. Now we need to find out the name contains Linda and change the cell color to blue.
![How To Auto Fill Color in Excel Based on Key Words? How To Auto Fill Color in Excel Based on Key Words?](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-4-830x720.png)
Firstly, select the name area and go to the Home tab and click on the More Highlight Cells Rules behind Conditional Formatting.
![How To Auto Fill Color in Excel Based on Key Words? How To Auto Fill Color in Excel Based on Key Words?](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-5.png)
Select the second one, Format only cells that contain. Then we choose Specific Text →Containing, enter the keyword “Linda” in the box.
![How To Auto Fill Color in Excel Based on Key Words? How To Auto Fill Color in Excel Based on Key Words?](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-6.png)
At the last, set the format, and change the cell color to blue.
![How To Auto Fill Color in Excel Based on Key Words? How To Auto Fill Color in Excel Based on Key Words?](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-7.png)
![How To Auto Fill Color in Excel Based on Key Words? How To Auto Fill Color in Excel Based on Key Words?](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-8-810x720.png)
Now all the cells containing Linda were founded in blue cells.
Leave a Reply