Forum Discussion
Excel help
Your question is quite unclear. Can you explain little more and show your input data and desired output manually. We will try to achieve that output by formula.
Hello Harun24HR and thank you for your response. very much appreciated
Today a visual inspection of the racks are carried out using a notebook, later to record into an excel. The format is very poor.
In its simplest format, for example and using the above table as a live example.
Inspection carried out starting alphabetically in Aisle A from Bay 1 to Bay 8 and will include all other aisles and bays. The Inspection is looking for defect/damage to any of the 4 components that assemble the racking (Upright, Beam, Pins and Crossbar). If any defect is identified it is recorded by severity, Red, Amber, Green (like traffic light system), to prioritise the repairs. Red being the most severe. All defects are repaired/replaced within time frames according to the severity. Hope this offers some clarity.
Again referring to the table and only as an example,
Aisle A, Bay 1 is showing a Pin defect/damage and the inspector has determined the fault to be of Red severity (most severe) importance to repair
Aisle C, Bay 3 is showing a Beam defect/damage and the inspector has determined the fault to be of Amber severity (medium severe) importance to repair.
The question is, is it possible to create an inspection record that can record a severity colour and the damaged component in the same cell ? drop downs or formulas ?
I am able to use conditional formatting to achieve one of the two requirements, but unfortunately I am inexperienced to do both. Can you help ? Any assistance again would be greatly appreciated
