Select cells with string "KO"




I had a datatable with many "KO" result i want to select the corresponding rows,   using select, and coloring the first row with red.


If you already have the datatable loaded with the rows that you need to select from you should be able to create an array of datarows and then assign it the corresponding rows using the code below. InputItems would be your datatable and replace “Item” with the name of the column you are checking for the string “KO”.


Once you have them all in an array you could write them back to a spreadsheet or some other table and highlight the first row (based on however you sort it). Hope this helps.