Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: MS Excel Urgent Help Needed

23 Mar 2011   #1

Windows 7 32 bit
MS Excel Urgent Help Needed

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 System SpecsSystem Spec
25 Mar 2011   #2

Windows 7 Home Premium 64bit

My System SpecsSystem Spec
31 Mar 2011   #3

Windows XP

Have you got the solution. Let us know
My System SpecsSystem Spec


 MS Excel Urgent Help Needed

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar help and support threads
Thread Forum
urgent help needed
Right firstly my laptop disk drive doesn't work so a factory restore is out of the question. Disk checker was running and my laptop shut off midway through, since then my laptop hasn't been working because windows explorer is not responding. Safe mode works perfectly fine. What could be the...
Performance & Maintenance
***very urgent help needed! Please try!***
Ill make it quick. I accidently waxed my father's brown shoe black and now it has black spots all over it. What can i do to fix it? I got almost half an hour! Please HELP!
Chillout Room
Urgent help needed
My deviantArt account has been taken by someone. Please someone tell me how to either recover it or close it.
Chillout Room
Urgent help needed please! :(
hi guys, i really need help. I cant find the stereo mix in my pc :( I previously used win xp (installed the drivers from the cd) and had the stereo mix. now, I'm using windows 7 64 Bit and I didn't install anything from the CD because i thought it's already supported. Now I can't find my...
Sound & Audio
URGENT Help needed
Hello again I recently (today) got a Samsung N310, I downloaded and mounted a RTM version of Windows 7, However when I try to run the setup I get this message, saying that I have tyhe wrong version for this version of windows im running? what do I do the ISO is a x64bit and the netbook Has 2GB of...
Installation & Setup
I'll make a long story short. I'm on Build 7100, and for some reason, all of my DL'd apps (Ones that weren't bundled with W7) were deleted, and/or they stopped working. I couldn't open anything. I end up re-installing W7, and I have two problems: 1. I can't install Java, which would make a...
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 19:04.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App