Conditional formatting color for specif cells

[NilsPR]

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  

[v-xuxinyi-msft · Accepted solution]

Hi @NilsPR 

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.

[NilsPR]

Hello @v-xuxinyi-msft 

It's exactly what I wanted. Thanks a lot.