i have excel data colored in Red in column A in excel and i want to apply filter only on red color data and also Column B i want to apply filter where value is greater than 0 Out put should be Data Amount 23 123 45 234 ty 7 [color data filter.xlsx attachment](upload://4S5Jgfxvqw…

i have excel data colored in Red in column A in excel and i want to apply filter only on red color data and also Column B i want to apply filter where value is greater than 0 color data filter.xlsx (9.2 KB)

Hi @T_Y_Raju Save the below vba as text file and use invoke vba activity Sub FilterRedCells() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet name ' Clear any existing filters If ws.AutoFilterMode Then ws.AutoFilterMode = False ' App…

will this code filter data only with red font colored

Yes use this one. Sub FilterRedCells() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet name ' Clear any existing filters If ws.AutoFilterMode Then ws.AutoFilterMode = False ' Apply filter to Column A for red colored cells ws.Range…

this macro is applying only filter on required column but filtering the data by color

Hi @T_Y_Raju After doing what @AJ_Ask sent you, use Filter Activity present in Excel Activities and filter by your desired condition. Thanks

Hi @T_Y_Raju , This thread will help you in applying a color based filter in column A. [image] Filter Rows Based on Color Studio Hi Guys, I want to filter the excel sheet rows based on the color. Color will be Light Green. Please check the below screenshot. (Note: Excel…

Hi @T_Y_Raju To filter the ColumnA with color and Column B which is greater than 0. Then you have to use the Vb macros to filter the data. You can use the below vb code, Sub FilterData() Dim ws As Worksheet Dim lastRow As Long Dim colorFilterRange As Range Dim valueFilterRange As …

Hi @T_Y_Raju You can use the Vb macros to apply the filter for ColumnA which is in red color and Column B which is greater than 0. Sub FilterData() Dim ws As Worksheet Dim lastRow As Long Dim colorFilterRange As Range Dim valueFilterRange As Range ' Set the worksheet S…

Hi @T_Y_Raju , You can follow my blog for the same. [image] Extracting Filtered Data in UiPath Based on Cell Color in Excel Sheets In every automation, We do a lot of interactions with Excel Application. For example: Filtrating the data, Changing the format, Running the VBA, Creating t…

Apply filter on multiple columns

Help Activities

Gautham_Pattabiraman (Gautham Pattabiraman) July 5, 2024, 2:48am 8

Hi @T_Y_Raju ,

This thread will help you in applying a color based filter in column A.

You can use the Filter activity from excel package to set the value based filter in column B.

Thanks,
Gautham.

Topic		Replies	Views
Filter Rows Based on Color Studio studio , question , activities_panel	31	2514	June 23, 2023
How to appy red font color data to excel data in uipath Studio uiautomation	27	475	July 3, 2024
Is it possible to filter an excel column by color? Studio studio , question , activities_panel	1	93	November 25, 2024
How to filter by colour in a column Automation Ops question , automation_ops	4	101	March 18, 2025
Filter excel and color rang Activities uiautomation	13	2741	January 11, 2021

Apply filter on multiple columns

Related topics