Apply color for column result based on yes and no

Help Activities
, ,
6

Hey @Venkat5 are you trying to do something like this to check if value is Yes then Fill with green or else Red then here is the solution.

A UiPath workflow screenshot showing an Excel Application Scope that reads data from "Sheet2" of "Data1.xlsx" and iterates over each row in a data table named "dt2". (Captioned by AI)
A UiPath workflow screenshot showing an Excel Application Scope that reads data from "Sheet2" of "Data1.xlsx" and iterates over each row in a data table named "dt2". (Captioned by AI)731×357 15 KB

The image shows a snippet of an automation workflow where a row's condition is checked, and if it equals "Yes", the cell in the specified range on "Sheet2" is set to green color. (Captioned by AI)
The image shows a snippet of an automation workflow where a row's condition is checked, and if it equals "Yes", the cell in the specified range on "Sheet2" is set to green color. (Captioned by AI)520×313 11.7 KB

A section of an automation workflow showing an "Else" condition where the range color is set to red for Sheet2, followed by an increment of the Index variable by 1. (Captioned by AI)
A section of an automation workflow showing an "Else" condition where the range color is set to red for Sheet2, followed by an increment of the Index variable by 1. (Captioned by AI)532×410 13 KB

and this Index is a Int Variable that i created in for each row

This image shows a highlighted section of a UI Path workflow, specifically the "For Each Row in Data Table" activity configured with a data table "dt2" and an index setting named "Index." (Captioned by AI)
This image shows a highlighted section of a UI Path workflow, specifically the "For Each Row in Data Table" activity configured with a data table "dt2" and an index setting named "Index." (Captioned by AI)934×203 15.4 KB

cheers