Excel – I want to highlight a cell in worksheet 1 when text has been entered into a cell from worksheet 2?
I was given a project at work to do a vacation calendar, specifically the first worksheet with a whole year calendar that fits onto the screen, then a blown up month in a separate worksheet. Here EMPLOYEES WILL WRITE IN WHEN THEY WANT TO TAKE A DAY OFF OR THEIR WEEKS, . What I want to do is so that whoever opens up the spreadsheet, it takes them to the first worksheet with the year summary. However in that same entire year calendar, for a specific date to highlight, fill, or alert if someone has made a change to a cell in lets say the worksheet where July is found.
Here’s an Excel template Vacation planner/calendar for employees. It costs ~$20 but you can download a free trial to check it out. It looks like it has what you are asking for?
Vacation Planner 2.1
http://www.topshareware.com/Vacation-Planner-download-37197.htm
Vacation Wall Calendar
|
|
Lone Elm Studios Perpetual Calendar Glass Magnet Set – Appointments & Holidays $29.99 Pretty glass magnets highlight holidays and appointments with charm and style. Set of 24 includes 11 holiday and 13 appointments. Colors and artwork may vary from image. Perfect for use with our metal perpetual calendars or on any magnetic surface…. |
|
|
2011 Organizer Wall Calendar 22×13 with Stickers Large Dates Lined $15.00 The new year brings new adventures, new occasions, and a new way to keep them all organized! The 2011 Organizer Calendar puts time on your side! This fun and festive 12-month calendar features extra-large lined date squares with plenty of room to write in important info. Plus, each month includes a large Notes section for reminders and comments. Every month is decorated with a fun and festive seas… |
|
|
House of Doolittle 6655 – Framed Planner, 90 day, 32 x 21 1/2, Silver-HOD6655 Keep track of important dates, vacations and project deadlines with this flexible planner. Undated so you can start whenever it’s convenient for you. Design includes space for notes and color-coding. Surface wipes clean with a damp cloth. Re-use over and over. Mounted to durable hardboard for long life. Frame includes hanger. Includes four water-soluble markers (black, blue, green and red). Large … |
|
|
National Lampoon’s Christmas Vacation (Special Edition) $5.50 It’s hilarious holiday havoc for Chevy Chase and his brood, as the Griswolds’ plans for an old-fashioned family Christmas go up in smoke (just like their cat!) when a horde of boorish relatives descends upon their home. Comedic carol of calamities also stars Beverly D’Angelo, Randy Quaid, Brian Doyle-Murray, Julia Louis-Dreyfus, and Juliette Lewis. 97 min. Widescreen (Enhanced); Soundtracks: Engli… |
|
|
National Lampoon’s Christmas Vacation (Special Edition) $6.49 You know exactly what you’re getting in National Lampoon’s Christmas Vacation: another goofball, slapstick comedy of chaos and catastrophe with Clark Griswold (Chevy Chase) and family. This time, there’s no traveling involved: Clark and Ellen (Beverly D’Angelo) prepare for a nice Christmas with the kids (played by none other than Juliette Lewis and Roseanne star Johnny Galecki), when their home is… |
|
|
Calendar $10.48 The only real event in Calendar happens in between the lines, yet this sliver of a movie will remain in your head long after many more action-packed movies have faded away. Canadian writer-director Atom Egoyan plays a photographer who is sent to photograph Armenian churches for a calendar; but while there, his wife (Arsinee Khanjian), who functions as his interpreter, begins to fall in love w… |
|
|
Mac Video Training Guide on CD-ROM, Quick Start to iPhoto, Tutorial, for Mac & Windows $14.95 Taking the picture is only the beginning! Learn how to import, edit and share your precious memories using iPhoto 08. Sit back and watch us demonstrate how to get the most from your digital photos and create your own color prints, slide shows, professional greeting cards, personalized calendars and even publish your own hard cover coffee-table photo book. Most importantly, we will show you how to … |
|
|
Neoprene Protective Glove Cover Sleeve with Soft Silky Smooth Interior Fur Padding for Samsung Galaxy P 1000 Tablet + SumacLife TM Wisdom Courage Wristband, Pink Trim $14.99 Upon opening this case you will find that the interior is covered with a soft silky smooth faux fur to provide your device with extra protection from dents and scratches. An Interior padded pocket has been added to provide extra storage for your Samsung Galaxy Tablet accessories such as USB data cables and memory cards. This case has been specifically manufactured to fit the Samsung Galaxy Tablet … |
Tags: vacation calendar, vacation calendar 2011, vacation calendar 2012, vacation calendar excel, vacation calendar excel template 2011, vacation calendar sharepoint, vacation calendar software, vacation calendar template, vacation calendar template 2011, vacation calendar template 2012