I need to create a spreadsheet for my project (dont worry its not homework). I have put as much as I can together but there are a few challenging things that I am stuck on and I need your technical expertise. I have attached the Excel file as well as a detailed Word file explaining exactly whats going on (if you want some background).
This is what I need to add onto my spreadsheet but Im not sure how to do this. I have tried googling for hours but I havent found anything useful because these are quite particular requests.
- Password protection on each sheet (with different passwords per person thaty they can customize). The main sheet should be only accessible by a certain moderator
- The line should highlight a certain colour when its a certain type e.g. complete = blue.
- Anything you type (per row) into any persons sheet should automatically type into the main sheet and change colour of course. The main sheet changes should override any other changes.
- I need a timer so if an issue isnt resolved in 24 hours it turns a certain colour.
I just need the basic formulas etc and Ill extend it to suit my needs. (So please post really accurate instructions or an excel file or something please)
Thanks in advance!
Edited by LSEactuary, 23 March 2011 - 02:24 PM.