Skip to Content
0

Conditional format last column

Mar 17, 2017 at 07:51 PM

47

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Mar 17, 2017 at 08:07 PM
0

try similar to this.

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

Share
10 |10000 characters needed characters left characters exceeded