Forum Discussion
MYGreenlee
Nov 09, 2020Copper Contributor
Auto fill multiple rows
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 whe...
mtarler
Nov 09, 2020Silver Contributor
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.