How to set conditional formatting based on different numbers

Hi ST123 ,

I suggest you to create color measures for each column and then set conditional formatting in cell elements.

For reference: Apply conditional formatting in tables and matrixes

My Sample:

I use Field value for Format stype in background color.

Measure:

Jul Color = 
 IF(SUM('Table'[Jul])>=SUM('Table'[Target]),"Green","Red")

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.