How to set Green color in excel for selected range?

How to set Green color in excel for selected range


this is my data …
what i need is after filling first row data in form it will set green color to first row…
then it will go to second row then fill form for 2nd row then it will set green color to second row…

@NervousTuber - You can use set range color inside excel application scope…

Here is the sample

Output

image

1 Like

What should i write in Range field?

@NervousTuber - Whatever range you wished to colorized… In my case I gave “A1:A2” as hardcoded…

If its dynamic , build you logic and use that variable in the range…

I am new to this … I dont know how to set color to per row after completing one iteration … :smile:

try thiswriteColorPerticularCell.xaml (6.2 KB)

1 Like

na dude its not working…


can you tell how to write “DONE” in status field after completing each iteration…