Forum Discussion
Solved
How can highlight selected rows in the array.
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.
If have a no "Total" text in the rows, just only sum of values. How can we use conditional formating?
Do you have another keyword in the cell of column G? How can you identify it?
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)