Hello all
I just can't seem to get my head round this. I want to do something really simple, and I just can't get it straight.
I am trying to compile a list of names. This is the situation :- We have sent out an invite. We are receiving back replies. I want the spreadsheet to show green if they respond "Yes", blue if they respond "No" and purple if they respond "Unsure".
My conditional formatting formula is very simple, the formula is if the cell value = "Yes", then turn it green. However, as soon as I try to apply it to other cells, it all goes wrong. I have tried selecting all the cells, and then applying the formula, but some of the cells turned green, then as I clicked into the column which controlled the conditions, the white cells then turned green as I clicked down them, even though the cell value was empty. If I then turned the response to "No", the cells remained green.
I have read the article on this website about conditional formatting, which is when I tried selecting all my cells first, but obviously I'm still doing something wrong.
At the moment, I seem to be saying that if any of the cells contain the value "Yes" then turn the cells green. But equally, I'm also saying if any of them equal "No", then turn the cells blue. Which may be confusing Excel somewhat.
Please can anyone help?
I just can't seem to get my head round this. I want to do something really simple, and I just can't get it straight.
I am trying to compile a list of names. This is the situation :- We have sent out an invite. We are receiving back replies. I want the spreadsheet to show green if they respond "Yes", blue if they respond "No" and purple if they respond "Unsure".
My conditional formatting formula is very simple, the formula is if the cell value = "Yes", then turn it green. However, as soon as I try to apply it to other cells, it all goes wrong. I have tried selecting all the cells, and then applying the formula, but some of the cells turned green, then as I clicked into the column which controlled the conditions, the white cells then turned green as I clicked down them, even though the cell value was empty. If I then turned the response to "No", the cells remained green.
I have read the article on this website about conditional formatting, which is when I tried selecting all my cells first, but obviously I'm still doing something wrong.
At the moment, I seem to be saying that if any of the cells contain the value "Yes" then turn the cells green. But equally, I'm also saying if any of them equal "No", then turn the cells blue. Which may be confusing Excel somewhat.
Please can anyone help?