Is there any way to apply conditional formatting if a value meets criteria in another column? For instance, I have a grid displaying revenue over a number of years, but I want to highlight data that occurs after a “call-out date.” However, it appears that I can only apply conditional formatting based on the revenue values themselves and am unable to reference the date column.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
@Britt, It sounds like you are using the conditional formatting in the UI. Currently, this feature can only interpret the measures it’s being applied to, and can’t reference a “call-out-date” or another field.
However, this can be accomplished by using conditional formatting with the html parameter. This gives more granular control over which cells to apply conditional formatting rules. Check out this conditional formatting with
htmlarticle to see some examples of how to do this.
Thanks for the question!
its been 4 years since this post, can we now apply conditional formatting based on another columns value ? meaning:
I read the article listed above and they only apply the formatting to the same column, meaning:
How do I do this ?
Would love this feature as well. Or at least the ability to format strings with conditionals.
Would love this feature as well ! thanks