Empty cells in column of excel need to fill with specific color

Hi all,

Excel file has empty cell that has to be filled with specific color.
How to set color for empty cells.
image

image
Please help.

Thanks,
Lakshmi

Hey,

You can use Set Range Color Activity in Uipath.
image

Thanks

Hi @Rounak_Kumar1 ,

Empty cells has to filled with specific color.

Thanks,
Lakshmi

Hi @lakshmi.mp

Using Brute force approach. It can be optimized further. If the data is not much this can be used

FillEmptyCellsWithColour.xaml (10.3 KB)

1 Like

Hi @kumar.varun2 ,

Its working for 10 rows of data, What if the rows are like 50,100.

Thanks,
Lakshmi

@lakshmi.mp

It will work

1 Like

@kumar.varun2, @Rounak_Kumar1,
Thanks for helping and providing the solution.

Thanks,
Lakshmi

1 Like

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