Conditional Formatting to Conditional Column if Null Field

Hi  BulldogTom ,

Here are the steps you can follow：

1. Create measure.

Color =
var _datediff=DATEDIFF(MAX('Table'[RTA Current]),TODAY(),DAY)
return
IF(
    MAX('Table'[RTA Actual])<>BLANK(),"gray",
    IF(
        MAX('Table'[RTA Actual])=BLANK()&&_datediff<30,"yellow",
        IF(
         MAX('Table'[RTA Actual])=BLANK()&&MAX('Table'[RTA Current])<TODAY(),"red"  
)))

2. [[RTA Current] – Conditional formatting – Background color.

3. Result:

Best Regards,

Liu Yang

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