Conditionally formatting a value in a straight table?

[#1]

Hi Guys

I have a straight table-  I want to be able to change the background color of a cell within a dimension if a particular value is present.

Can anyone help?

Thanks

[sushil353 · Accepted solution]

Hi,

Please find attached file. here you can set condition in Expression>background.

Similarly can be done for dimension

HTH

Sushil

[#3]

Expand axis that you've added, select Background color and edit its formula like this:

=If(YOURAXISNAME='XXX', Red(), White())

[#4]

These are really helpful! Thank you

I have one more quick question.

How do I format a dimension as a % within a straight table and how do I format a dimension that currently shows 800000 as 800,000

I can only see how I would do this if it is an expression.

Thank you in advance

[#5]

bump

[sushil353]

use somethig like

=num(fieldname,'##0.0%')

edit dimension.

HTH

Sushil

[#7]

i have list report with out any expression how can i make conditional formatting based on "YES" and NO

if it is NO back ground should be RED

[Anonymous]

Hi Mohammed,

You can create an empty expression and in background color  - give condition or you can give in dimension - background color the condition.

Regards

Neetha.

Note: please start new thread for new query's.

[justaqlikker]

Thank you.  This is wonderful.  I am now able to get perfect conditional formatting to be able to highlight outliers or invalid data.  Also, I use this to highlight rows of net totals which I calculate and even to create alternating shading in a table in order to improve readability.