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 color must to be black.
Also I have maybe 30 differents column to color, how can I use this formula with all.
Thanls
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.
2 Replies
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.