#1
|
|||
|
|||
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. |
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 |