Auto fill multiple rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1868998%22%20slang%3D%22en-US%22%3EAuto%20fill%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1868998%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20highlight%20an%20entire%20row%20based%20on%20a%20search%20of%2038%2C000%20rows.%20In%20one%20column%20there%20are%20multiple%20variables%2C%20one%20of%20which%20is%20%22FST%2C%22.%20I%20want%20to%20be%20able%20to%20find%20every%20instance%20in%20this%20one%20column%20where%20%22FST%2C%22%20exists%20and%20highlight%20that%20entire%20row%20automatically.%20I%20have%20already%20discovered%20that%20there%20are%204762%20instances%20where%20%22FST%2C%22%20is%20in%20column%20I.%20I%20can%20change%20the%20format%20so%20that%20the%20individual%20cell%20is%20highlighted%2C%20but%20I%20don't%20want%20just%20the%20cell%20highlighted.%20I%20want%20the%20entire%20row%20highlighted%20%22FST%2C%22%20without%20having%20to%20individually%20highlight%20each%20one.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1868998%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1869096%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1869096%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863194%22%20target%3D%22_blank%22%3E%40MYGreenlee%3C%2FA%3E%26nbsp%3B%20Select%20the%20entire%20table%20and%20then%20in%20conditional%20formatting%20select%20custom%20formula%20and%20then%20enter%20something%20like%3A%3C%2FP%3E%3CP%3E%3D%24D1%3D%22FST%22%3C%2FP%3E%3CP%3EWhere%20D%20is%20the%20column%20you%20want%20to%20search.%3C%2FP%3E%3CP%3EAnd%20of%20course%20select%20the%20formatting%2Fhighlighting%20you%20want%20to%20be%20applied.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I need to highlight an entire row based on a search of 38,000 rows. In one column there are multiple variables, one of which is "FST,". I want to be able to find every instance in this one column where "FST," exists and highlight that entire row automatically. I have already discovered that there are 4762 instances where "FST," is in column I. I can change the format so that the individual cell is highlighted, but I don't want just the cell highlighted. I want the entire row highlighted "FST," without having to individually highlight each one. 

1 Reply
Highlighted

@MYGreenlee  Select the entire table and then in conditional formatting select 'New Rule' and then select 'Use a formula to determine which cells to format' and then enter something like:

=$D1="FST"

Where D is the column you want to search.

And of course select the formatting/highlighting you want to be applied.