How to set color in excel


#1

hey i working on excel sheet i want to set the color of row so when the status is "Match i want to show complete row with yellow color in excel sheet i inserted data dynamically


I would like to set background color for the datarow
#2

Hey @pankaj

You can use Set Range Color activity here.

You can check this post for sample workflow :slight_smile:
Fill excel color / highlight cells

Regards…!!
Aksh


#3

but how to set the range in set Range Color for my requirement because data is inserted dynamically


#4

Hey @pankaj

If you are using it in a loop then also you can use counter and assign that with range like this “A”+counter and so and so till what cell count you want.

Regards,!!
AKsh