I'm having the issue where I want to set the color "Red" to Red and "Green" to Green.  For the workbook attached, the calculated field "value color" will yield either Green or Red based on whether the value is under 3 or not.  Currently all of my values are over 3, therefore I can set the color of "Green" to Green (default is blue).  However, it does not let me set the color "Red" to Red until a value below 3 actually appears in the data set. 

is there a way to adjust that color as well without there being currently data for that specific logic?

Thanks!