Colour excel cell with conditional

Help
1

Hey
I have a dataTable (let’s call DT1) with 2 columns, one with a date and one with gender.
I have to paint in a colour those rows which are “Male” or “M” and in other colour those rows which value is “Female” or “F”.
how can i read the DT1, select column Gender and say to Uipath that “F” goes in Red and “M” in yellow.
thanks for ur time

2

hi,
you can iterate via data table and check for each row and its column and then set the color of the excel range. Please see attached flow.Main.xaml (10.8 KB)

3

@Ignacio_Smail Best approach would be to create an excel template file with all conditional formatting rules set.

4

can u insert the image? i cant open the file u sent.
tks

5

image

image

image

please let me know if you got the solution or not.

2 Likes
7

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