The formula is like
IF (EASy Utilization)< 0.4 THEN 'RED'
ELSEIF (EASy Utilization) >=.4 AND (EASy Utilization)<= .49 THEN 'YELLOW'
Thank you so much for taking a look.
A problem still remains with the proposed solution- the file I attached is a mock up of my actual workbook. So, there are cases where the Zone has > 0 transactions but the EASy is 0%. I need these to be colored "RED".
Is there a way to add an IF statement to my calculated field "Coloring"? Something like IF [Number of Records] = 0 THEN "GREEN"?
Thanks for all your help!
The above conditionals seem to have included your cases. Right?
Show me another mockup where the above formula doesn't work.
You are correct...thanks!