You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can I use conditional formatting on a rollup heading?

Received Response
12
Views
2
Comments
edited Jan 30, 2018 3:21PM in Reporting & Analytics for B2C Service 2 comments

Content

I have been trying to find an answer to this simple question: Can I use conditional formatting on a rollup heading?

I have a simple report: a regular data column, followed by two "concat" columns that merge data from other columns together. Only the three columns are visible, and I use rollup on the top two columns. When the data meets a time condition of 86400, I want the text data in the columns to turn red.

I have tried this with both conditional formatting and data exception formatting. It works well both ways for a regular column heading and data, but does not when I change the top two columns to rollup format (the rollup heading does not reformat).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!