Wednesday, June 7, 2017

yogi_Conditionally Format Entire Row Where The SearchBox Item is Found Any Where In The Corresponding Row

Google Spreadsheet   Post  #2177
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-07-2017
question by Thomas KM:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/-gIkDcJbil8;context-place=forum/docs
How do I create a function to highlight cells that contain text specified in a search cell
Hello,
I was wondering if you might be able to help me with an issue I'm facing creating a search/highlight cell in a spreadsheet. I'm looking to be able to type a word into a box at the top of my sheet and then have every row where this word occurs highlighted in the sheet below. I see that there are a few ways to do this in Excel, but I haven't been able to do this here. 
Thank you,
Thomas

Here is a link to the sheet I've been working on:
https://docs.google.com/spreadsheets/d/1N3hZqcradkbm7Y7MAED73nDHT_yXkSSettkctjj3_Rc/edit?usp=sharing
Here is a link to the kind of thing I'm looking for:
https://exceljet.net/tips/how-to-build-a-search-box-to-highlight-data