Apply color for column result based on yes and no

[Venkat5 (Venkat)]

I had a data table with columns and under column result values will be yes and no if it is yes I need to mark green ,if no I need color red for that particular cells I need to create html table for this

[ashokkarale]

@Venkat5,

Follow these steps.

1. Loop through the DataTable: Iterate over each row and column.
2. Check Value Conditions: For each cell, check if the value is “Yes” or “No”.
3. Generate HTML Code: Based on the condition, set the background color of the cell to green (for “Yes”) or red (for “No”).

Code outline like this.

' Start building the HTML table
htmlString = "<table border='1'>"

' Add header row
htmlString &= "<tr>"
For Each column As DataColumn In yourDataTable.Columns
    htmlString &= "<th>" & column.ColumnName & "</th>"
Next
htmlString &= "</tr>"

' Add data rows
For Each row As DataRow In yourDataTable.Rows
    htmlString &= "<tr>"
    For Each cell As Object In row.ItemArray
        If cell.ToString().Equals("Yes") Then
            htmlString &= "<td bgcolor='green'>" & cell.ToString() & "</td>"
        ElseIf cell.ToString().Equals("No") Then
            htmlString &= "<td bgcolor='red'>" & cell.ToString() & "</td>"
        Else
            htmlString &= "<td>" & cell.ToString() & "</td>"
        End If
    Next
    htmlString &= "</tr>"
Next

' End the table HTML
htmlString &= "</table>"

[sagar.singh1 (Sagar Singh)]

Hello @Venkat5,

Use this code:-

Colored Table table { width: 50%; border-collapse: collapse; } th, td { border: 1px solid #ddd; text-align: center; padding: 8px; } .yes { background-color: green; color: white; } .no { background-color: red; color: white; }

Name	Result
John	Yes
Jane	No
Sam	Yes
Anna	No

Output:-

[singh_sumit (Sumit Singh Tariyal)]

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.

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

cheers

[Venkat5 (Venkat)]

Thanks @ashokkarale this approach works.

[ashokkarale]

Glad to hear @Venkat5.

Kindly close the thread by marking the answer as solution.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…