Change text color based on value in Datatable

I’m trying to work out some conditional formatting for a few columns.

Let’s say:
if Column2 value = “nok” , color red
if Column2 value = “ok”, color green


Is this possible? (3.0 KB)

You would need to read the datatable in and then in a for each loop use your condition.
You can then set the font colour of that cell (based on calculating the range e.g. B2) using Change Font Colour
You will need to amend the code slightly :slight_smile: