Skip to Content
avatar image
Former Member

Conditional format last column

I want to apply conditional formatting only on the last column on a cross table. (The red/green color in the picture) I can do it like this if I always know the number of columns:

This is one of my formatting rules:

=ColumnNumber() = 13 And [R/1000] < Previous([R/1000])

How can I do it if I don't know the number of columns?

capture2.png (11.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 17, 2017 at 08:07 PM

    try similar to this.

    =([Measure object]) Where ([YYWW]=Last([YYWW]) In Block)

    Add comment
    10|10000 characters needed characters exceeded