| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of Yes Response
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Yes Response
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Yes Response
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Yes Response
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Yes Response
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Yes Response
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Yes Response
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum of Yes Response
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Response | Excel Discussion (Misc queries) | |||
| How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
| How do I set up a daily call out response response register? | Excel Worksheet Functions | |||
| value response | Excel Discussion (Misc queries) | |||
| can I get some help here? No response yet :) | Excel Worksheet Functions | |||
![JohnR[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
