# How to Filter Data with Specific columns in Excel

**URL:** <https://forum.electroneek.com/t/how-to-filter-data-with-specific-columns-in-excel/1380>\
**Category:** Studio Pro\
**Tags:** excel\
**Created:** [September 29, 2022, 3:49am UTC](https://forum.electroneek.com/t/how-to-filter-data-with-specific-columns-in-excel/1380 "2022-09-29T03:49:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bhaskar](https://forum.electroneek.com/user_avatar/forum.electroneek.com/bhaskar/32/602_2.png) [@Bhaskar](https://forum.electroneek.com/u/Bhaskar)\
**Post date:** [September 29, 2022, 3:49am UTC](https://forum.electroneek.com/t/how-to-filter-data-with-specific-columns-in-excel/1380/1 "2022-09-29T03:49:40Z")

</div>

How to Filter data based on column names and need to apply color in cell values. Can you please help me

---

<div class="post-metadata">

**Author:** ![Kudlappa\_Gouder](https://forum.electroneek.com/user_avatar/forum.electroneek.com/kudlappa_gouder/32/371_2.png) [@Kudlappa\_Gouder](https://forum.electroneek.com/u/Kudlappa_Gouder)\
**Post date:** [September 29, 2022, 10:25am UTC](https://forum.electroneek.com/t/how-to-filter-data-with-specific-columns-in-excel/1380/2 "2022-09-29T10:25:10Z")

</div>

@Bhaskar You can use ‘Execute macro’ activity to filter and format the cells.  
Please refer below article on how to use ‘Execute macro’ activity

> **[Execute Macro](https://help.electroneek.com/hc/en-us/articles/360020254318-Execute-Macro)**
>
> Description
> 
> This activity requires having Microsoft Excel installed on the computer.
> 
> This activity allows you to execute a .vbs-macro in the selected Excel file.  Studio Pro supports Microsoft Ex...

---

<div class="post-metadata">

**Author:** ![Bhaskar](https://forum.electroneek.com/user_avatar/forum.electroneek.com/bhaskar/32/602_2.png) [@Bhaskar](https://forum.electroneek.com/u/Bhaskar)\
**Post date:** [September 29, 2022, 10:28am UTC](https://forum.electroneek.com/t/how-to-filter-data-with-specific-columns-in-excel/1380/3 "2022-09-29T10:28:17Z")

</div>

Sure, Thanks for the reply. We used python script , we will check this as well
