# Using a select control to highlight a row **URL:** \ **Category:** Ask the Community\ **Created:** [December 18, 2020, 2:56pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244 "2020-12-18T14:56:13Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Robin\_Bigio](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/robin_bigio/32/17345_2.png) [@Robin\_Bigio](https://connect.superhuman.com/u/Robin_Bigio)\ **Post date:** [December 18, 2020, 2:56pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/1 "2020-12-18T14:56:13Z")
Hi there, I am trying to create the behavior that if I select an item using my selector, it both shows the corresponding table value inline, AND highlights the row in the table. Here is an example. https://coda.io/embed/S4D5XFGaTN?viewMode=embed When exploring the conditional formatting option, I see an option to create an interactive filter, which works great. But the I cannot use that control to pull up the inline value. Thanks! ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [December 18, 2020, 3:55pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/2 "2020-12-18T15:55:06Z")
Hi there @Robin_Bigio 😊 ! I’m not sure I understood correctly your question 😊, but is this what you were trying to do ? https://coda.io/embed/KSjU1IKJn1/_suer9?viewMode=embedplay&hideSections=true ---
**Author:** ![Robin\_Bigio](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/robin_bigio/32/17345_2.png) [@Robin\_Bigio](https://connect.superhuman.com/u/Robin_Bigio)\ **Post date:** [December 18, 2020, 4:31pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/3 "2020-12-18T16:31:09Z")
YES! That’s it! For some reason I cannot open the formulas or conditional formatting options in your doc. Can you share? ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [December 18, 2020, 4:57pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/4 "2020-12-18T16:57:55Z")
> [@Robin\_Bigio](#): > > For some reason I cannot open the formulas or conditional formatting options in your doc. That’s weird 😕 … But I had the same trouble with your doc though 🤔 … Well, for the conditional formatting, it’s the same thing as you’ve probably already done in your sample. Here, I create the interactive filter when I create the conditional formatting 😉 . ![Capture d’écran 2020-12-18 à 17.54.25](https://global.discourse-cdn.com/coda1/original/3X/a/d/adc55d422ff455d4f285d6d18eb228b41949f610.jpeg) Now, for the formula for the “ **you get** ”, it’s this one : ```auto [Table 1 2].Filter([Column 1].Contains([Select Table 1 2])).[Column 2] ``` ![Capture d’écran 2020-12-18 à 17.50.46](https://global.discourse-cdn.com/coda1/original/3X/1/5/15931f917d80fda07194fa248d28138969e622f4.png) I hope this helps 😊 ! ---
**Author:** ![Robin\_Bigio](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/robin_bigio/32/17345_2.png) [@Robin\_Bigio](https://connect.superhuman.com/u/Robin_Bigio)\ **Post date:** [December 18, 2020, 6:10pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/5 "2020-12-18T18:10:11Z")
Yes it did the trick! Thanks!!! ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [December 18, 2020, 6:16pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/6 "2020-12-18T18:16:34Z")
You’re welcome 😁 ! ---
**Author:** ![Robin\_Bigio](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/robin_bigio/32/17345_2.png) [@Robin\_Bigio](https://connect.superhuman.com/u/Robin_Bigio)\ **Post date:** [December 18, 2020, 6:26pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/7 "2020-12-18T18:26:04Z")
@Pch — one quick followup. For some reason the **you get** returns value within [square brakets]. See below, any ideas why? ![Screen Shot 2020-12-18 at 10.23.52 AM](https://global.discourse-cdn.com/coda1/original/3X/e/7/e7d5e0e976553b4e73754eb043382b1f37c4f0a7.png) ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [December 18, 2020, 6:41pm UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/8 "2020-12-18T18:41:11Z")
Hmm 🤔 … would you mind sharing a screenshot of your actual formula @Robin_Bigio ? 😊 It might just have something to do with how you formatted your actual table (at least those 2 fields) … The brackets indicates there’s a list somewhere 😉 (if I’m not mistaken) … So, this might be easy to correct 😉 . Edit : You could also try : `[Table 1 2].Filter([Column 1].Contains([Select Table 1 2])).[Column 2].ToText()` Or `[Table 1 2].Filter([Column 1].Contains([Select Table 1 2])).[Column 2].ListCombine()` But without knowing how your field is formatted, I might be wrong here 😊 ---
**Author:** ![Robin\_Bigio](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/robin_bigio/32/17345_2.png) [@Robin\_Bigio](https://connect.superhuman.com/u/Robin_Bigio)\ **Post date:** [December 19, 2020, 1:37am UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/9 "2020-12-19T01:37:21Z")
.ToText() worked!!! brilliant, thanks so much @Pch! ❤ ---
**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\ **Post date:** [December 19, 2020, 10:59am UTC](https://connect.superhuman.com/t/using-a-select-control-to-highlight-a-row/20244/10 "2020-12-19T10:59:47Z")
Ah 😁 ! I’m very glad to know one of the suggestions did the work @Robin_Bigio 😁 !! (I had at least one or two left, if necessary 😊 )