warehouse racking file

[mdb231]

Hi All.
I have just been sorting out an excel file for the warehouse locations for pallet spaces.
What I was trying to do was if a was in a space I could either use an EU for euro pallet or UK for a UK pallet which are bigger than the Euro pallet it would turn Red to say there was a pallet there already if it was empty it would be green.
Apart from that I was trying to give a count of pallet spaces left as well as a percentage.
The file will follow shortly.

EDIT:
Total pallet spaces =
Both pallets Pallet spaces used =
RACK A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 spaces
E 1 1 1 1 1 1 E E 60
D C C
C 1 1 C C
B A A
A 1 A A

Both pallets
Rack B 1 2 3 4 5 6 7 8 9 10 11 12 spaces
F 72
E 1
D
C 1 1
B 1 1
A


Both pallets
Rack D 1 2 3 4 5 6 7 8 9 10 11 12 spaces
F 72
E
D 1 1 1 1 1 1
C 1
B 1
A 1 1 1 1


Both pallets
Rack D 1 2 3 4 5 6 7 8 9 10 11 12 spaces
F 1 72
E 1 1
D 1 1
C 1 1 1
B
A 1 1


Both pallets spaces
Rack H 1 2 3 4 5 6 7 8 9 10 11 12 72
F 1 1 1 1 1 1 1 1 pallets pallets pallets pallets pallets
E 1 1 pallets pallets pallets pallets pallets
D 1 1 1 1 1 1 1 1 1 1 1 pallets pallets pallets pallets pallets
C 1 1 1 1 1 1 1 1 1 1 pallets pallets pallets pallets pallets
B 1 pallets pallets pallets Fire exit and
A pallets pallets pallets Fire extinguisher

 

[mdb231]

The 1's in the rows are where pallets are located already, Each rack has 6 rows of 12 spaces apart from a row which can go to 14 at the end of each rack I have put 72 which would be the amount of pallet spaces for the rack.
I hope this helps.
I have forgotten how to use the site regards adding screen shots as not been doing it for a while been busy with family.
Anyway thanks for looking and any help would bev much appreciated.

 

[Joe4]

There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.