Conditional format based on two dates (with changing values)

Hi KBO ,

I have first cleaned up the relationships a bit.

After that I created the following measure for formatting. I hope it helps.

TL = 
VAR _Logic =
    FILTER (
        Logic,
        Logic[Start] <= SELECTEDVALUE ( 'Date'[End of Month] )
            && Logic[End] >= SELECTEDVALUE ( 'Date'[End of Month] )
    )
VAR _Value = [Total Values]
RETURN
    MAXX (
        _Logic,
        SWITCH (
            TRUE (),
            _Value <  [Green ], "green",
            _Value <= [Yellow], "orange",
            _Value >  [Red], "red",
            "grey"
        )
    )