LSEactuary
New member
- Local time
- 2:42 PM
- Messages
- 1
Hi,
I need to create a spreadsheet for my project (don’t worry it’s 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.
The below is what I need to add onto my spreadsheet – but I’m not sure how to do this. I have tried googling for hours but I haven’t found anything useful because these are quite particular requests.
- Password protection on each sheet (with different passwords per ‘person’ that they can customize). The main sheet should be only accessible by a certain ‘moderator’. Please note that no one should be able to view eachothers sheets apart from the moderator.
- The line/whole row should highlight a certain colour when it’s a certain ‘type’ e.g. complete = blue.
- Anything you type (per row) into sheet 2,3,4.... should automatically type into the main sheet (sheet 1) and change colour of course. The main sheet changes should override any other changes and vice versa. It needs to look organised though (sheet 1) and not a mess.
- I need a timer so if an issue isn’t resolved in 24 hours it turns a certain colour. If this i not possible then maybe it can be done by date. ie green when typed on 12th march. turns red when its the 13th of march.
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!
I need to create a spreadsheet for my project (don’t worry it’s 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.
The below is what I need to add onto my spreadsheet – but I’m not sure how to do this. I have tried googling for hours but I haven’t found anything useful because these are quite particular requests.
- Password protection on each sheet (with different passwords per ‘person’ that they can customize). The main sheet should be only accessible by a certain ‘moderator’. Please note that no one should be able to view eachothers sheets apart from the moderator.
- The line/whole row should highlight a certain colour when it’s a certain ‘type’ e.g. complete = blue.
- Anything you type (per row) into sheet 2,3,4.... should automatically type into the main sheet (sheet 1) and change colour of course. The main sheet changes should override any other changes and vice versa. It needs to look organised though (sheet 1) and not a mess.
- I need a timer so if an issue isn’t resolved in 24 hours it turns a certain colour. If this i not possible then maybe it can be done by date. ie green when typed on 12th march. turns red when its the 13th of march.
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!
My Computer
- OS
- Windows 7 32 bit
