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   Jun-07-2017
question by Thomas KM:!topic/docs/-gIkDcJbil8;context-place=forum/docs
How do I create a function to highlight cells that contain text specified in a search cell
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,

Here is a link to the sheet I've been working on:
Here is a link to the kind of thing I'm looking for: