Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2013, 12:16 PM
Mitka Mitka is offline Modify a template Windows 7 64bit Modify a template Office 2013
Novice
Modify a template
 
Join Date: Sep 2013
Posts: 1
Mitka is on a distinguished road
Default Modify a template

Hi,
I hoping someone can assist me here. I downloaded the Employee Attendance Tracker template which I'm trying to modify to suit my needs.



The original template had 6 fields of which 4 fields are reflected in color.
The remaining 2 fields were modified to for the other 2 types of leave that we have. This works fine but I am unable to get the color to reflect in the calendar and I have no idea how to adjust.

Any help in adjusting this template would be greatly appreciated.

I attached the one that I am working on and the original one.

Thanks,
Mitka
Attached Files
File Type: xlsx Employee attendance tracker Original.xlsx (35.9 KB, 11 views)
File Type: xlsx Employee attendance tracker Modified.xlsx (63.0 KB, 13 views)
Reply With Quote
  #2  
Old 09-29-2013, 07:00 PM
excelledsoftware excelledsoftware is offline Modify a template Windows 7 64bit Modify a template Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by Mitka View Post
Hi,
I hoping someone can assist me here. I downloaded the Employee Attendance Tracker template which I'm trying to modify to suit my needs.

The original template had 6 fields of which 4 fields are reflected in color.
The remaining 2 fields were modified to for the other 2 types of leave that we have. This works fine but I am unable to get the color to reflect in the calendar and I have no idea how to adjust.

Any help in adjusting this template would be greatly appreciated.

I attached the one that I am working on and the original one.

Thanks,
Mitka
I really tried to help on this but since I do not currently have the version of office you are using. I am quite limited. It appears to be a conditional formatting issue and I am not sure how many conditions your version can support. If it can accept 6 you may just need to give the cells the other condition.

Sorry I can't be of any more help.
Reply With Quote
  #3  
Old 09-30-2013, 07:08 AM
BobBridges's Avatar
BobBridges BobBridges is offline Modify a template Windows 7 64bit Modify a template Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I have the right version of Excel, but I looked at that template and threw my hands up in horror (no, not literally ); the formulae used there are quite a challenge. I still hope someone smart will look at this—Pecoflyer seems to be good with array formulae, which is what your template is using—but if no one else will tackle it, I'll try to get to it later today.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Modify a template Picture to not modify table remodel Word Tables 1 10-05-2012 09:59 AM
Modify default template to include file path jacl Excel 1 03-26-2011 10:24 AM
How to modify the citation format MREGLIER Word 0 02-19-2011 03:31 AM
Word Template... modify (edit) valis Word 0 12-16-2010 12:51 PM
Disable/Modify MOC.exe worthydaydream Office 3 04-23-2010 10:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft