Aussiebear
08-07-2008, 01:45 AM
How difficult would it be to generate a colour for a named range, which is detemined by the data being entered into a flat file spreadsheet?
In the attached workbook, the User will be entering data on the "Data" sheet;
Date, Pen#, Pen Area Effected, Equipment in Operation, Hours, etc. I'm hoping that from this data the Pen Number, and the section of Pen effected, can be selected on the "Map" sheet, and the relevant named range can then be coloured according to the type of machinery having been used in the operation.
Each of the Pens have four named ranges. For example if Pen 11 was the active Pen, you could have Whole of Pen (Whole), Front of Pen (Front), Under Shade (Shade), or Rear of Pen (Rear) as the options. I have gone to the trouble of nameing all of the ranges with the following concept, P11W, P11F,P11S,P11R. In the Legend section of the "Map" sheet, there is an example of the colour formatting I am seeking to apply.
In the attached workbook, the User will be entering data on the "Data" sheet;
Date, Pen#, Pen Area Effected, Equipment in Operation, Hours, etc. I'm hoping that from this data the Pen Number, and the section of Pen effected, can be selected on the "Map" sheet, and the relevant named range can then be coloured according to the type of machinery having been used in the operation.
Each of the Pens have four named ranges. For example if Pen 11 was the active Pen, you could have Whole of Pen (Whole), Front of Pen (Front), Under Shade (Shade), or Rear of Pen (Rear) as the options. I have gone to the trouble of nameing all of the ranges with the following concept, P11W, P11F,P11S,P11R. In the Legend section of the "Map" sheet, there is an example of the colour formatting I am seeking to apply.