Change color of excel cell with if condition

[ZebaT (Sujitha)]

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

[fernando_zuluaga]

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

Regards

[ZebaT (Sujitha)]

I found this solution

UiPath - Set Cell Color, Alignment, Font Style | Format Cell Activity |UiPath Tutorial

[Aleem_Khan (crazy bot)]

You can also look into this video.

Modern format cell activity uipath