I am in the Air Force and my unit wants me to create a spread sheet with pushups situps and runtime for our pt test. We will be doing a mock test every month to see progress of our members. I need to show improvment or not in the spreadsheet. Such as if in Jan I do 50 pushups then Feb I do 52 I would like for that to show up green for improvement red if I got less and yellow if stayed the same. I will be doing each month on its own sheet. The only way I have found to do this is naming the prior months cell and usng conditional formating to create the three rules seperatley. This works but with over 50 members and doing this every month there seems like there has to be a quicker way. Any input would be appreciated. I don't know ton about excel but I learn quick.
Also the run time I would need to be the opposite with green for less yellow for same red for more.
Please ask any questions if you dont understand my ramblings.