I work for a training organisation and am setting up basic record keeping spread sheets for online students to download and complete with a macro button that unhides an identical sheet. On this duplicate sheet I'm using the Conditional Formatting function to shade in green the cells where they get the answer correct and red shaded cells if it is incorrect.
In each document I'm building, there can be up to 100 individual cells to do the conditional formatting to. To make it quicker by default the cells are shaded red and my conditional formatting basically says when the answer sheet is equal to their answer, shade the cell green. I had been doing this for 2 frustrating days on each individual cell when it dawned on me that I can use the format painter tool to create the rules on each cell quickly and then just go into each cell and edit the rule with the correct cell reference.
Now that I've done this they seem to all be linked to the final cell that I pasted to using the format painter tool. If that cell is correct then all cells go green but if that cell is incorrect then they all stay red. I deleted the rule for the final cell and they all linked to the 2nd to last cell doing the same thing. When I go in to look at the rules they all have unique cell references and all the cell references are absolute.
I have a pretty basic understanding of Excel and what I do know I learned from Google and YouTube. Any help would be appreciated.
Thanks
Bookmarks