Highlight specific cell

Help Activities
, ,
1

I found minimum value in the excel table. How I can highlight the minimum value ?

3

Hi @Teaf ,

You can use below activity to highlight any cell or row

image

4

How can i know the minimum ( What i found ) index to put it in range?

5

If u get the rowindex and column index under which minimium value resides you can get the corresponding cell name to it.

Using that u can set the range in set color activity

Regards

Nived N :robot:

6

Hey, check this post to get minimum value.

7

If that does not work use this to find min value

image
image1326×546 36.3 KB

Once you have min value, pass it to lookup activity to get row number and highlight it.

Let me know if you face any issue.
Thanks

8

I need to find the min value in each row, So i created below workflow

Capture
Capture605×645 23.5 KB

9

Excel table :
ta

10

I didn’t get it previously you asked how to get min row.

So the question is are you able to get min row value or not ?

11

No i found the min value but i need to highlight the min cell ?

12

Try below steps:

1 - Create index from Output property which will tell you the row number.
And also do do index=index+2 to get exact excel row number

image
image1003×355 13.5 KB

2 - Column counter you are already maintaining.
So you have to pass the column index number to below code and you will get the Address of cell like A,B,C,D

image

image
image711×339 13.7 KB

13

How can i found row index or column index?

14

Inside the for each row loop, if you had find the value corresponding to a row, then u can write cell address for it using the following method

Convert.ToChar(columnIndex + 64).ToString+(dt1.Rows.IndexOf(row)+2).ToString

You will get the cell address using this

1 Like
15

Thank you !

16

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