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

My Resource Tracking System Test.xlsx (70.6 KB, 12 views)