This is a migrated thread and some comments may be shown as answers.

Conditional Formatting when there's a blank value

2 Answers 82 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Christopher Ronak
Top achievements
Rank 1
Christopher Ronak asked on 24 May 2014, 11:23 PM
Hello,
I'm trying to use conditional formatting to uniquely format a whole row in a report. The condition I'm using is a property of the row itself, not of any particular value. In this case, the boolean property I'm using to determine whether to format the row is called, "IsSummaryRow".  If it's true, then I format the row.  The problem I'm coming across is when there are blank or missing values in the row (which is common), the conditional formatting doesn't get applied. The boolean property is not affected by the other values in the row. I'm using an object data source.
I've attached a screenshot so you can see what I mean. 
I'd appreciate your help.

Chris

2 Answers, 1 is accepted

Sort by
0
KS
Top achievements
Rank 1
answered on 28 May 2014, 04:06 PM
Hi,

The conditional formatting must be applied on an item in the report. If you hide the item if there is no data, the result could be as the on your screenshot.

-KS
0
Kieron
Top achievements
Rank 1
answered on 25 May 2020, 01:04 PM

Would you by any chance know the value entered to conditionally format a blank cell.

For instance i want to conditional format a report cell to turn grey if its not used however im unaware of the value of a blank cell.

If the Expression is : ="the question" and the Operator is "=" then what can i make the "Value" to except the format for a no content in the cell.

 

Any help would be great

Tags
General Discussions
Asked by
Christopher Ronak
Top achievements
Rank 1
Answers by
KS
Top achievements
Rank 1
Kieron
Top achievements
Rank 1
Share this question
or