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?

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?

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?

Hi,

This assumes your cells are formatted as %

CF1 cell value - is greater than 0.85 - Green
ADD
CF2 cell value - is greater then 0.65 - Amber
ADD
CF3 cell value - is greater than 0 - Red

Mike


"JohnR" wrote:

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?

Hi Mike,
Yes each cell is formatted as a %. The Edit Formatting Rule shows Green =
..86 and the Type as Percent.... the value in this case is 59% and it shows as
Green icon...when it should be a red icon (being < .65... ???

"Mike H" wrote:

Hi,

This assumes your cells are formatted as %

CF1 cell value - is greater than 0.85 - Green
ADD
CF2 cell value - is greater then 0.65 - Amber
ADD
CF3 cell value - is greater than 0 - Red

Mike


"JohnR" wrote:

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?

Can you give us the exact settings/formula for your CF?
--
John C


"JohnR" wrote:

Hi Mike,
Yes each cell is formatted as a %. The Edit Formatting Rule shows Green =
.86 and the Type as Percent.... the value in this case is 59% and it shows as
Green icon...when it should be a red icon (being < .65... ???

"Mike H" wrote:

Hi,

This assumes your cells are formatted as %

CF1 cell value - is greater than 0.85 - Green
ADD
CF2 cell value - is greater then 0.65 - Amber
ADD
CF3 cell value - is greater than 0 - Red

Mike


"JohnR" wrote:

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?

Posting your formula(s) would help.
--
John C


"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?

The formula is simple =COUNTIF(D2:D44,"yes") from there it calculates a
percentage. After that I confgured the CF.....

"John C" wrote:

Posting your formula(s) would help.
--
John C


"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?

I was actually wanting the formula for your conditional formatting.... :)
--
John C


"JohnR" wrote:

The formula is simple =COUNTIF(D2:D44,"yes") from there it calculates a
percentage. After that I confgured the CF.....

"John C" wrote:

Posting your formula(s) would help.
--
John C


"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?