Highligh Cell of the Filtered Data

Help Studio
,
1

Hello All
I seek help on this. I need the the workflow to highlight the blank cells in column B:
This image shows an Excel spreadsheet with two columns labeled "Name" and "Status," listing names from "Abc" to "Ibc" with some corresponding statuses "Yes" or "No." (Captioned by AI)
the workflow will first filter status and return all the blank cell in B:
image
the bot will then highlight the “blank cell”.

would like to seek help, if it is possible to have this done? TIA

3

@f5f191b0815b26e83996fd67f

This is a screenshot of a UiPath workflow sequence that uses Excel activities to open an Excel file named "Excel1.xlsx" and apply a filter on the "Status" column of "Sheet1." (Captioned by AI)
This is a screenshot of a UiPath workflow sequence that uses Excel activities to open an Excel file named "Excel1.xlsx" and apply a filter on the "Status" column of "Sheet1." (Captioned by AI)818×898 36 KB

A software interface displaying an "Advanced filter" tool with an "Is empty" condition selected. (Captioned by AI)

Input:

The image shows a table with columns labeled "Name" and "Status," listing names from "Abc" to "Ibc" with corresponding statuses "Yes," "No," or blank. (Captioned by AI)

Output:

A spreadsheet with columns labeled "Name" and "Status" shows a list of names in the "Name" column from rows 4 to 10, while the "Status" column is currently empty. (Captioned by AI)

Regards,

4

@f5f191b0815b26e83996fd67f

  1. Use excel file activity
  2. For each row in excel
  3. If condition to check if status is blank currentRow("Status").ToString.Equals("")
  4. On then side use set range color(this is classic activity) or can use format cells as well

Cheers

5

For the range what should I put?

6

@f5f191b0815b26e83996fd67f

For range in for loop use excel.sheet("Sheetname")

Cheers

7

But I only wan to highlight status column that.
When I use the excel sheet range. It highlight the whole excel sheet…

8

Hi, @f5f191b0815b26e83996fd67f

Code:
Rowindex is a integer

The image shows a sequence of actions in UiPath's workflow for reading an Excel file, iterating through its rows, and conditionally updating the cell color based on a specific condition. (Captioned by AI)
The image shows a sequence of actions in UiPath's workflow for reading an Excel file, iterating through its rows, and conditionally updating the cell color based on a specific condition. (Captioned by AI)1147×784 44 KB

Result:
image

9

@f5f191b0815b26e83996fd67f

if youa re talking about using in set range color then use

CurrentRow.ByField("ColumnName").Address

if inside format cells

Excel.Sheet("SheetName").Range(CurrentRow.ByField("ColumnName").Address)

This image depicts a sequence of actions in a user interface, particularly for formatting cells and setting range colors in an Excel sheet using specified parameters such as the column name and the sheet name. (Captioned by AI)
This image depicts a sequence of actions in a user interface, particularly for formatting cells and setting range colors in an Excel sheet using specified parameters such as the column name and the sheet name. (Captioned by AI)947×627 23.3 KB

Hope this helps

cheers

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.