SOLVED

How can highlight selected rows in the array.

Iron Contributor

Hi,

I would like to highlight on the last rows in an array. But when the data is update, the highlights has moved as the image below.
Hope for your response.
Thank you.

small_village_0-1664037584218.png

 

8 Replies
best response confirmed by littlevillage (Iron Contributor)
Solution

@littlevillage 

You can use conditional formatting.

dscheikey_0-1664041441328.png

 

 

@dscheikey 

Thank you dsheikey,

That's worked.

@dscheikey 

If have a no "Total" text in the rows, just only sum of values. How can we use conditional formating?

@littlevillage 

Do you have another keyword in the cell of column G? How can you identify it?

@dscheikey 

The highlights is sum of values like below image.

How can we do that?

small_village_0-1664124185034.png

 

@littlevillage 

In this case it would be possible to work with the ISFORMULA() function in the conditional formatting. See here:

dscheikey_0-1664126694042.png

If you want to make sure that only cells with SUM() formulas are selected and no other functions, you can use the following function in the conditional formatting.

=IFERROR(FIND("SUM(",FORMULATEXT($B2))>0,FALSE)

 

@dscheikey 

This is the first time, I know ISFORMULA() and FORMULATEXT(). That's great functions.

In the array, i try to use them, but they are not worked.

 

@littlevillage 

In your array, every cell has the same formula, so there are no differences here. Therefore, you need the keyword "Total" there.

1 best response

Accepted Solutions
best response confirmed by littlevillage (Iron Contributor)
Solution

@littlevillage 

You can use conditional formatting.

dscheikey_0-1664041441328.png

 

 

View solution in original post