How to color if values is available and write match in other column

[Charbel1 (Charbel)]

BOM_Comparision.zip (623.1 KB)
I changed some stuff in the paths, so just copy the part that I updated.

For the “NEW” part, you can use this Write Cell activity:

The cell value is:

"P" + intcellv.ToString