I have the following data, where the Actual and On Track column values change daily.

Consultant    Actual    On Track    Monthly Goal    
Fernando      371         524           550               
Michael         584         524           550              
Keith            374         524           550                  
Ken              187         524           550                 
Lance           354         524           550

I create a bar chart that from this data, and display the data label for Actual.  I would like to format this data label so that it displays in Red if the value of Actual is less than the value of On Track.  Otherwise, it will just display as Blue, which is the format color right now.  I tried Conditional Formatting on the data in the table, but that does not transfer color to the chart.  Is there a way to do this?

Thanks!