Skip to Content
avatar image
Former Member

Color change the last column, with Formatting Rules

Hello community,

I have a question with formatting Rules.

You need to change Color of the cells only in the last column, the 12th


As seen in the screenshot I have done:

= Last ([Body] <[Avg_body]

But all the rows and columns of the table are marked.

Any idea how to fix it?

Thanks you!



Capture.JPG (110.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 26, 2015 at 03:04 PM

    Select only the particular column to apply the formatting rules. It seems that it has been applied to all the columns of the WebIs.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Miquel,

      Glad it worked!

      The formula Last(Valores) In "Block" gets the last value of values in the Block. Block here, means a table/chart/crosstab etc. If we write In Report, that would get the last value in the entire Report.

      The difference is, you may have data for other Valores in the Report, but what if you have filter in this table/chart on Valores, to show only 1 to 6? Then Last(Valores) In Block will get you number 6 as its the last value in this Block.

      Make sense? Hope that helps.


      Mahboob Mohammed