Highlight Double Column Values in a DataTable Using HTML Inside a For Each Row LoopcurrentRow("Amount") = "<b style='color:red;'>" + currentRow("Amount").ToString + "</b>"

[HELZMOTH_BJ]

I am using the expression currentRow(“Amount”) = “” + currentRow(“Amount”).ToString + “”
, but it does not work because the column Amount is of type Double. I want to highlight the cell value using HTML formatting directly in the DataTable, not in Excel, since I am sending the DataTable as an HTML table through Outlook.

[ashokkarale]

@HELZMOTH_BJ

You can do it by adding another column for highlighted Amount column and assign the desired html tag string for each column in this new column.

Before sending this data as html, remove the orginal amount column with double datatype.

[HELZMOTH_BJ]

I am sending the mail inside for each for every row. so how can i remove the original column

[Anil_G (Anil Gorthi)]

@HELZMOTH_BJ

after adding new column use a filter datatable activity and give the column names you want to remove..it would remove it

cheers

[ashokkarale]

@HELZMOTH_BJ,

If you are iterating rows one by one, then it’s better to just prepare html string inside the loop.