Скачать или смотреть Highlight cell in first column if row contains a partial text match

Hello everyone! I hope this video has helped solve your questions and issues. This video is shared because a solution has been found for the question/problem. I create videos for questions that have solutions. If you have any other issues, feel free to reach out to me on Instagram:   / ky.emrah  

Below, you can find the text related to the question/problem. In the video, the question will be presented first, followed by the answers. If the video moves too fast, feel free to pause and review the answers. If you need more detailed information, you can find the necessary sources and links at the bottom of this description. I hope this video has been helpful, and even if it doesn't directly solve your problem, it will guide you to the source of the solution. I'd appreciate it if you like the video and subscribe to my channel!Highlight cell in first column if row contains a partial text match

I would like to highlight cells in the first column if there is a partial string match in the same row. The spreadsheet has 100 rows and 100 columns. I would like this applied to the majority of the spreadsheet except a couple header rows.
I would like to be able to determine if any of the cells in that row contain the word "missing" and then highlight (fill) the first column in that row. I would also like this to be case insensitive.
I am using Microsoft Office 365 online if that makes any difference.
For example I would want cell A18 highlighted if BB18 was " 0.0 Missing Done 1 ".


Tags: excel,office365Source of the question:
https://stackoverflow.com/questions/7...

Question and source license information:
https://meta.stackexchange.com/help/l...
https://stackoverflow.com/