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.
- Looker Staff
- 17 replies
-
11 August 2017
Hi
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 html article to see some examples of how to do this.
Thanks for the question!
Userlevel 2
its been 4 years since this post, can we now apply conditional formatting based on another columns value ? meaning:
I have a field that takes a value “checked” so , if checked then measure green, else red.
I read the article listed above and they only apply the formatting to the same column, meaning:
if checked then column green, else red
How do I do this ?
dimension 1: status
measure: sales
if status = checked then turn sales green, else turn sales red
Would love this feature as well. Or at least the ability to format strings with conditionals.
Would love this feature as well ! thanks
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.