How To Set Color of Row Based on Value on Cell?

Dears,
Is there a way to change font color of text in excel rows based on condition in one of it’s cells ?
Thanks

Buddy @hsendel
you can use SET RANGE COLOR activity where you can mention the range and color you want like this

Cheers

2 Likes

Hi Palaniyappan,
I want to color text not the cell itself, also my query is when the cell is dynamic, it search for value in case found it will color the text of the whole row.

As an example, it will search for cells in column2 in case there is value “0” it will set the color of row as red as follows :
image

Hi Palaniyappan,
Perfect!!! Problem Solved using your proposal inside For Each Activity

2 Likes

Cheers buddy @hsendel
keep going

2 Likes

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