Excel Colour Issue

Help
, , ,
1

Hi ,

I have created a data table mentioned below and pasted the same in Excel it is working. Now I need to individually check the Number column counts and if the count of two number columns matches i.e 123 will have 3 counts and 773 will have 3 ,then I need to color it with the same color. Please help me on this. Following is my excel data.
Name Number
abc 123
sadfhkq 49345
dfiughkjidg 25908
jhdfg 773

2

Fine
–use excel application scope and pass the file path as input
–inside the scope use read range activity and get the output with a variable of type datatable named dt
–now use FOR EACH ROW actiity and passthe variable dt as iput
–inside the loop use IF condition like this
row(“yourcolumnname”).ToString.Length(3)
if true it will go to THEN part where we can use SET RANGE COLOR Activity
if its column C
then in range mention as “C”+(dt.Rows.IndexOf(row)+2).ToString
and color as system.drawing.color.red

Cheers @Pranav_Kashyap

3

we don’t know the count which will be equal, how to check it dynamically?

1 Like
4

fine instead of 3 we can mention a variable of type int32 so that the count can be passed based on our need
or do you have any otther scenario
Cheeers @Pranav_Kashyap

5

The Scenario is we need to check the Number column each data length if the length of one cell matches with the length of other cell we need to make the whole row in same color