Forum Discussion
Conditional formatting color for specif cells
Hello, I would like to color a specific cells for a specific row. For example here I would like = if values is "coverage" and the results in the column 3/29/2024 is 0 then the backgroung ...
Hi Anonymous
Here is my testing:
I restored some of your data.
Then I did something as follows.
Create a measure:
Measure = IF(MAX([Values]) = "Coverage" && MAX([3/29/2024]) = 0, "Black", BLANK())Result:
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Here is my testing:
I restored some of your data.
Then I did something as follows.
Create a measure:
Measure = IF(MAX([Values]) = "Coverage" && MAX([3/29/2024]) = 0, "Black", BLANK())
Result:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
It's exactly what I wanted. Thanks a lot.