Conditional Formatting - Table with Multiple Measures

Hi power bi friends. Could someone help me out on this one please. So I have a table with static data (5 years & 1 year column) and with different measures (YTD column)

I wanted to have a conditional formatting with the YTD column like data bar that says if YTD column is nearing to reach the 1 year column, the color will be turned into orange, then if YTD is nearing to reach the 5 year column it will then turned into green. Please note that the YTD column has different measures and value on it so I am not sure if right-clicking and set the conditional formatting would work. Thanks in advance!

See YTD column measures:

YTD Measure = IF (
    HASONEVALUE ( 'KPI Financial Planning'[Category] ),
    SWITCH (
        VALUES ( 'KPI Financial Planning'[Category] ),
        "$EBIT", [$EBIT Financial Planning],
	    "$Revenue", [$Revenue FP],
	    "Average Revenue/Client $", [Average Revenue/Client $],
	    "Client facing team members", [No. of Clients FP],
        "EBIT% of revenue", [EBIT% of revenue FP],       
        "Enterprise Value", [Enterprise Value FP],
        "No. of business locations", [No. of Business Locations],
        "No. of Clients", [No. of Clients FP],
        "No. of equity holders", [No. of equity holders],
        "Revenue per FTE", [Revenue per FTE FP],
        "Total FTE team", [Total FTE Team FP],
        "Turnaround Days", [Turnaround Days FP],
        0
    ))