How to set Green color in excel for selected range?

Help
,
1

How to set Green color in excel for selected range

image
image829×277 7.4 KB

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…

2

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

Here is the sample

image
image1296×455 14.6 KB

Output

image

1 Like
3

What should i write in Range field?

4

@Vinit_Mhatre - 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…

5

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

6

try thiswriteColorPerticularCell.xaml (6.2 KB)

1 Like
7

na dude its not working…

image
image916×200 6.73 KB

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