SOLVED

How can highlight selected rows in the array.

Frequent 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 small_village (Frequent Contributor)
Solution

@small_village 

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?

@small_village 

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

 

@small_village 

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.

 

@small_village 

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