How to set the range color in data table?

Help
1

Trying to set range color. But the range is not constant.it’s a dynamic one.

For example:-
image

2

Hi @ganesh_rajan

Check the below post

How to specify range in Set Range Color

Thanks
Ashwin.S

3

Invoke macro is the suitable activity for your need.

Place a code inside macro file, to count the number of rows in an excel and set the color based on Status Column.

Regards,
Karthik Byggari

2 Likes
4

Hey @ganesh_rajan,

-Send Hot Key ctrl+A
-Use Get Selected Range which will give you the selected range.
-Use Set Range color Activity to set the range color.