Excel help

maybe add a number after like "Pin 3", "Pin 2" or "Pin 1" for low, med, high rank.  Then the conditional formatting can use a custom formula like =Right(B3,1)="1" for Red (or you can rank them in the opposite order, whichever way makes sense for you) where B3 is the upper left corner of the range (i.e. Aisles A and Bays 1) so the Applied To range would be B3:I9 in the above example.  Then repeat for "2" and "3" for Amber and "Green".

if you want to get 'fancy' you could define names like Pin1, Pin2, Pin3, Beam1, Beam2, ... in the Name Manager to be the corresponding values 1,2,3.  Then you could use 'standard' conditional formatting rules and Color based on Values.

Either way, you may want to use Data Validation (list) to restrict the entry to those options and give the user a helpful dropdown.  instead of listing all of them in the Data Validation window I would create the list on another sheet and just reference that list range.