changing the background color of the indicated column 1 row for better visibility when search ends

%3CLINGO-SUB%20id%3D%22lingo-sub-2978543%22%20slang%3D%22en-US%22%3Echanging%20the%20background%20color%20of%20the%20indicated%20column%201%20row%20for%20better%20visibility%20when%20search%20ends%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2978543%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%3A%20This%20has%20been%20bugging%20me%20for%20ages%20and%20I%20have%20been%20unable%20to%20find%20the%20answer.%20I%20am%20using%20Win10%20PC's%20with%20Office%20365%20and%20have%20a%20substantial%20spreadsheet%20of%20electronic%20components%20I%20use%20in%20my%20electronics%20hobbies.%20I%20have%20been%20adding%20to%20this%20sheet%20for%20some%20years%20and%20when%20doing%20a%20general%20search%20to%20see%20if%20I%20have%20in%20stock%20a%20specific%20component%20I%20always%20use%20a%20general%20search%20encompassing%20all%20columns%20and%20rows%20for%20any%20reference%20to%20what%20I%20am%20specifically%20looking%20for.%3CBR%20%2F%3ETrouble%20is%20my%20site%20is%20poorly%20at%2070%20years%20old%20and%20I%20often%20do%20not%20easily%20see%20the%20indicated%20row%20highlighted%20in%20column%201%20when%20my%20search%20completes.%20I%20have%20been%20unable%20to%20find%20out%20how%20to%20highlight%20the%20indicated%20Column1%20%3ARow%20x%20that%20my%20search%20indicates%20with%20a%20much%20brighter%20or%20more%20contrasting%20background%20color.%3C%2FP%3E%3CP%3EHelp%20would%20be%20truly%20appreciated%20with%20this%20one%20friends%2C%20I%20will%20attempt%20to%20generate%20a%20small%20example%20file%20to%20indicate%20what%20I%20am%20talking%20about.%20I%20am%20enclosing%20a%20portion%20of%20the%20file%20in%20question%2C%20please%20see%20cell%20M5%20for%20a%20bit%20more%20clarity.%20Thanks%20in%20advance%2C%20I%20am%20expecting%20someone%20to%20make%20me%20feel%20like%20the%20fool%20I%20am.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2978543%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2979441%22%20slang%3D%22en-US%22%3ERe%3A%20changing%20the%20background%20color%20of%20the%20indicated%20column%201%20row%20for%20better%20visibility%20when%20search%20en%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2979441%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1222128%22%20target%3D%22_blank%22%3E%40Cocosoft%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DAND(%24M%241%26lt%3B%26gt%3B%22%22%2CISNUMBER(SEARCH(%24M%241%2CA1)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20is%20the%20rule%20for%20conditional%20formatting%20you%20are%20looking%20for.%20Enter%20search%20value%20in%20cell%20M1%20to%20highlight%20the%20search%20result%20in%20column%20A%20in%20red.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi guys: This has been bugging me for ages and I have been unable to find the answer. I am using Win10 PC's with Office 365 and have a substantial spreadsheet of electronic components I use in my electronics hobbies. I have been adding to this sheet for some years and when doing a general search to see if I have in stock a specific component I always use a general search encompassing all columns and rows for any reference to what I am specifically looking for.
Trouble is my site is poorly at 70 years old and I often do not easily see the indicated row highlighted in column 1 when my search completes. I have been unable to find out how to highlight the indicated Column1 :Row x that my search indicates with a much brighter or more contrasting background color.

Help would be truly appreciated with this one friends, I will attempt to generate a small example file to indicate what I am talking about. I am enclosing a portion of the file in question, please see cell M5 for a bit more clarity. Thanks in advance, I am expecting someone to make me feel like the fool I am.

2 Replies

@Cocosoft 

=AND($M$1<>"",ISNUMBER(SEARCH($M$1,A1)))

 

Maybe this is the rule for conditional formatting you are looking for. Enter search value in cell M1 to highlight the search result in column A in red.

Thanks so much for your reply, I have tried it although not truly understanding what I was doing and it appears to highlight the border colors of the chosen cell in column A with a thin red line. Not sure if that is what you had in mind. I changed the width of the borders in column A so it would stand out more but this is not what I was looking for either. I was really hoping it was possible for the search to highlight the appropriate row number column with a stand out color or in lieu of that to highlight the whole row in a different color temporarily.
I will leave it here till I find out if I am making myself understood. Thanks again so much for trying to help, it's much appreciated