I have a spreadsheet with picked items on the First (original) page.
<tbody>
</tbody>
On the second page (Results)
Correct
NM
SDS
AS
APP
SM
TUL
WK
I would like to have a button to update the worksheet and show the correct results.
What I am wanting to do is, based on the "Correct" answers on the Second (results) Page, I want to Change the background color, in the cells, on the First(original) page, of the Incorrect answers and then in Column I, I want to report the Number of Incorrect answer.
I have tried to put formula's into Column I, but the only time they refresh is if I go into the actual cell and press enter. Also I cannot figure out how to do the Cell Highlighting in a macro instead of using the conditional formatting.
I would like to have this spreadsheet pretty much automated because it will be an ongoing project and all this manual manipulation is getting tedious.
Any and all suggestions will be greatly appreciated.
Thank you,
Tom Cusick
Name | B | C | D | E | F | G | H | I |
Jane Doe | NM | SDS | AS | App | SM | CM | WK | 6 |
John Doe | NM | Hou | AS | APP | SM | TUL | WK | 6 |
Jack Doe | NM | SDS | CF | Tol | SM | TUL | WK | 5 |
<tbody>
</tbody>
On the second page (Results)
Correct
NM
SDS
AS
APP
SM
TUL
WK
I would like to have a button to update the worksheet and show the correct results.
What I am wanting to do is, based on the "Correct" answers on the Second (results) Page, I want to Change the background color, in the cells, on the First(original) page, of the Incorrect answers and then in Column I, I want to report the Number of Incorrect answer.
I have tried to put formula's into Column I, but the only time they refresh is if I go into the actual cell and press enter. Also I cannot figure out how to do the Cell Highlighting in a macro instead of using the conditional formatting.
I would like to have this spreadsheet pretty much automated because it will be an ongoing project and all this manual manipulation is getting tedious.
Any and all suggestions will be greatly appreciated.
Thank you,
Tom Cusick