asked 6 days ago
We have a use case where we want to create a pivot that that displays like this where "Prior MRR" is in bold, there is a line after Churn, and MRR and ARR are 'bold' and 'bold italics' respectively. 
We have been able to reproduce the basic concept, but haven't been able to figure out an easy way to do the formatting of the line and the bold/bold italics. Is there a way with the conditional formatting to do this, or alternatively, could a feature be added to the roadmap to cover this so we aren't hacking javascript (since this feature would be super helpful in other use cases as well)
Here is what we got so far:
⋅ 5 days ago
Hello, Bill!
Thank you for reaching out to us.
Flexmonster allows conditional formatting rules to be limited to a particular row or column. By combining this with the condition that would be true for all values (like greater than 0), you can highlight rows by row index:
{
id: 1,
formula: "#value > 0",
format: {
fontStyle: "italic", // Dark yellow
},
row: 5,
}
However, the conditional formatting cannot be applied to string members in columns and rows, so we recommend highlighting the rows using the customizeCell: https://jsfiddle.net/flexmonster/t10gneoj/
This approach would provide the additional benefit of highlighting the same members after filtering or sorting is applied.
We are looking forward to hearing your feedback.
Best Regards,
Maksym
