Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2013, 02:32 PM
stockers stockers is offline Merging and Shading Cells based on Dates Windows 7 32bit Merging and Shading Cells based on Dates Office 2010 32bit
Novice
Merging and Shading Cells based on Dates
 
Join Date: Mar 2013
Posts: 4
stockers is on a distinguished road
Default Merging and Shading Cells based on Dates

G'day,



I have a spreadsheet (Attached) which I am using to try and track resources on a fireground etc. In the early stages to see if excel will do what i want it too. My Primary objective is to make it relatively easy to use and as automated as possible.

On the Resource Request sheet I have pretty much all the fields i want to put into this page. It needs a good clean up but i'm not going to put time into this until I know it works. Bascially I want the 'Travel Up Date' and 'Travel Home Date' to shade yellow and the 'Commence Work' and 'Conclude work' to merge and shade the cells Orange if there is a MO # or to show up blue if there isn't one...all of this on the 'Resource Allocation' Page. I have completed some manual examples of what I want automated on the page.

Thank you all in advance.
Attached Files
File Type: xlsx My Resource Tracking System Test.xlsx (70.6 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shading in Cells in Word Tables Cindy Word Tables 1 01-04-2013 02:38 PM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM
How can I change the colors of cells automatically based on Job Completion? Learner7 Excel 0 07-06-2010 10:47 PM
Finding the difference of two dates based on criterion. aligahk06 Excel 0 04-27-2010 12:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:59 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