Hii,
I have a column
col1 col2 col3 col4 col5
S
T
All
S
T
T
All
In this col1 whtever the different value is i need to color it but “All” and “S” Should be consider as same.
How to do it plss help
Hii,
I have a column
col1 col2 col3 col4 col5
S
T
All
S
T
T
All
In this col1 whtever the different value is i need to color it but “All” and “S” Should be consider as same.
How to do it plss help
Write Range activity to write to the excel
After that Read Range to read the excel and use For Each Row activity
Place If condition and check as below
row(“col1”).ToString <> “All” OR row(“col1”).ToString <> “S”
Then->Use Range Color
Else → Blank
Hope this may help you
Thanks
Hi
Hope the below steps would help you resolve this
Say you want to Color all the values in red and “ALL” - “S” in yellow Color
Use a excel application scope and pass the file path as input
Inside the scope use a read range activity and get the output as dt
Now use a FOR EACH ROW activity and pass dt as input
Inside the loop use a IF activity like this
CurrentRow(0).ToString.ToUpper.Contains(“ALL”) or CurrentRow(0).ToString.ToUpper.Contains(“S”)
If true it goes to THEN block where use a SET RANGE COLOR activity
And mention the properties like this
Range - Convert.ToChar(65+dt.Columns.IndexOf(“col1”)).ToString+(dt.Rows.Indexof(CurrentRow)+2).ToString
And Color as
System.Drawing.Color.Yellow
If it’s false it goes to ELSE BLOCK where use the same set of activities ur Color alone as System.Drawing.Color.Red
Cheers @Doonline
no I need to Compare it first then need to color it.But while comparison itself i need to make it as equal.Then only in comparison condition it will take is as same
May I know what to compare with which value
@Doonline