Change color of excel cell with if condition

I want to change color of the cell based on the text inside.

Ex: if the row contains(“.com”) then color yellow, but its coloring the whole column and not the selected cell containing the string

Hi @ZebaT

Use lookup activity to retrieve the cell name and then pass that cell value to the Range property of your set range color


I found this solution

1 Like

You can also look into this video.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.