Keeping color coordination when dragging information from sheet to Dashboard

Hey there everyone, I am dealing with an issue related to color coding and keeping the same color from the data sheet when pulled into a dashboard. A certain Project is in the "Yellow" status and is colored in Yellow font on my data sheet. However when I pull this cell and add it to the dashboard it changes back over to black or whatever I have the color of the font set too. I need to be able to update my data sheet and have the dashboard reflect that new update with the same color rather than going in and changing the font color manually on the Dashboard. So if the Project moves into "Green" Status it will change from the color font yellow to green just like it does on my data sheet. Here below is an example based on my dashboard and data sheet. Would be a huge help if anyone knows how to fix this or what to do next!