Sum of Yes Response
F9 does not alter it, so perhaps the CF was not set up correctly - any
suggestions with that?
"Mike H" wrote:
Hi,
Assuming you have correctly set up the CF's then maybe calculation is in
manual. What happens if you tap F9
Tools|Options|calculation
select automatic
Mike
"JohnR" wrote:
I am designing a survey with choice of "yes" and "no" responses. At the end
of survey it counts the number of "yes" responses and determines the score in
percentage. There are 3 categories - over 85% would recieve a green light
icon, between 65% - 85%, a yellow light icon, and below 65% a red icon. When
I set the conditional format, and then test and modify the number of yes
responses, the color of the icon does not change - any ideas?
|