I am trying to set up alerts for Text R,A,G (where R- Red, A - Amber, G - Green). I am not sure which component to use, I started out with Scorecard Alert feature but realized that it only allows the background of the cell to change colors. Is there a component or a trick or tip that is recommended for changing Font Color with the data. any guidance is much appreciated.
Sample Data:Date Name Status 1/1/2014 Jack R 2/1/2014 Bill A 2/15/2014 John R