I suggest that you download the app from the exchange called Magic Buttons by Kirk Trachy.
I am sorry but I'm just on an iPad now and cannot easily copy and paste from that app but there is a field called [red point option] which has a formula for a status bar which changes colors as the percent completed for a project advances from 0% to 100%.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------