So I am creating a multiple choice drop down test in excel and I want to make it where the cell would change to the color green if I get the answer right and red if I get it wrong. I know how to do it for each cell individually but that would take a VERY long time.
So what I thought I could do is make a copy of the column in a another spreadsheet (Label Answer) and make column in the test page (Label Test) change color based on the answer on the other spreadsheet.
Who what I did was create a new rule in the on the Answer column in "Test" page to change to the color green if the text matches the cells in the on the answer column in the "Answer" page in the same excel file.
the problem is that this only work on the first question, any question after that doesn't change color at all.
This is all done using the "format only cell that specific text"
Here is my example for anyone that can help me out.
https://www.dropbox.com/s/ncqt802s230eds7/Example%20Test.xlsx?dl=0
So what I thought I could do is make a copy of the column in a another spreadsheet (Label Answer) and make column in the test page (Label Test) change color based on the answer on the other spreadsheet.
Who what I did was create a new rule in the on the Answer column in "Test" page to change to the color green if the text matches the cells in the on the answer column in the "Answer" page in the same excel file.
the problem is that this only work on the first question, any question after that doesn't change color at all.
This is all done using the "format only cell that specific text"
Here is my example for anyone that can help me out.
https://www.dropbox.com/s/ncqt802s230eds7/Example%20Test.xlsx?dl=0