Hi Team,
I am using UiPath Studio 26.0.186.
I need to apply Excel Conditional Formatting → Highlight Cells Rules → Duplicate Values on:
Column AQ (Custom Data 12)
Column BY (Medical Invoice Number)
I want to do this using Modern Excel Activities only.
I do not want to use VBA or UI Automation.
Could anyone please guide me with the activity or workflow?
Thanks.
iampnkz
July 9, 2026, 3:18pm
2
Hi @swethareddy ,
Welcome to the community.
Check this:
Option 1: Using LINQ (C#)
Read the Excel data into a DataTable using the “Read Range” activity.
Use LINQ to filter and modify the data based on the “Attribute A” column.
Update the Excel file with the modified data using the “Write Range” activity.
var filteredData = dtData.AsEnumerable()
.Select(row =>
{
if (row.Field(“Attribute A”) == “Yes”)
row.SetField(“Attribute A”, “Dark Red”);
else if (row.Field(“Attribute A”) == “No”)
row.SetField(“Attribute A”, “Green”);
return row;
})
.Copy…
Thanks!
Anil_G
July 9, 2026, 3:31pm
3
@swethareddy
Welcome to the community
if you need conditional formatting then there is no activity as such …best was instead of vba is to creeate a template upfront with already the conditional formatting added and thena dd the data it would auto work
if not you need to go with computing and checking each line in UiPath using for loop then use set range color to change the color of each cell based on waht you need
cheers
Anil_G:
Welcome to the community
if you need conditional formatting then there is no activity as such …best was instead of vba is to creeate a template upfront with already the conditional formatting added and thena dd the data it would auto work
if not you need to go with computing and checking each line in UiPath using for loop then use set range color to change the color of each cell based on waht you need
cheers
Thank Anil for your response