Sep 24 2022 09:50 AM
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.
Sep 24 2022 10:45 AM
SolutionSep 24 2022 06:49 PM
Sep 25 2022 08:19 AM - edited Sep 25 2022 08:19 AM
If have a no "Total" text in the rows, just only sum of values. How can we use conditional formating?
Sep 25 2022 08:30 AM
Do you have another keyword in the cell of column G? How can you identify it?
Sep 25 2022 09:46 AM
Sep 25 2022 10:25 AM - edited Sep 25 2022 10:46 AM
In this case it would be possible to work with the ISFORMULA() function in the conditional formatting. See here:
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)
Sep 25 2022 01:15 PM
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.
Sep 25 2022 01:38 PM
In your array, every cell has the same formula, so there are no differences here. Therefore, you need the keyword "Total" there.
Sep 24 2022 10:45 AM
Solution