Hiya,
I have a series of questions on my spreadsheet. Some involve a Yes/No response and some have a Yes/No/NA response. I have conditionally formatted my responses so Yes=Green, No=Red, N/A =Grey
I am trying to see whether I could get Excel to automatically calculate a RAG rating. I would like a box at the bottom of the page that will show as green (if over 70% of responses are yes/green), amber (if between 40%-70% are yes/green) or red (if less than 40% are green/yes).
I have attached a test spreadsheet so hopefully you can see what I mean.
I think it will be the iF formula but I’m not sure?
Many thanks in advance.
Bookmarks