Color change the last column, with Formatting Rules

[Former Member]

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!

Cheers,

Miquel.

[former_member202257 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Shwetha,

The problem is I can't select a separate column. Selects entire table.

[mhmohammed · Accepted solution]

Hi Miquel,

As it's a cross tab, when you select one column, it will select all the columns, because you're not really selecting one column (you're selecting an object values, Valores). So, you need to update the formula/condition in the Conditional formatting window as below (in both the places in the Formatting Rule Editor window, you attached in the snapshot)

=(Last([Per_Head]) < [Media Per_Head]) and ([Valores] = 12) (in formula on top to highlight rows in red)

=(Last([Per_Head]) >= [Media Per_Head]) and ([Valores] = 12) (in formula at the bottom to highlight rows in green)

Let me know if that helps.

Thanks,

Mahboob Mohammed

[Former Member · Accepted solution]

Hi Mahboob,

It works. But the [Valores] = 12 value is a static value and this value change every week. It is not a fixed value.

I tried it with [Valores] = Last ([Valores]) but not working.

Any ideas?

Thank you!

Cheers,

Miquel.

[mhmohammed · Accepted solution]

Hi Miquel,

Try as [Valores] = Last ([Valores]) In Block (if that doesn't work, try, In Report)

Let me know if that helps.

Thanks,

Mahboob Mohammed

[Former Member · Accepted solution]

Perfect, this works.

What exactly does this "in Block" function?

Set a particular column?

Thank you very much!

Cheers,

Miquel.

[mhmohammed · Accepted solution]

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.

Thanks,

Mahboob Mohammed