shorten long if statement and add conditional formatting

[Lirpaloof]

long time viewer but this is my first post i really need help with this


IF(AND(B44=18,G3=52),Z52,IF(AND(B9=43,G13=24),Z58,IF(AND(B11=42,G3=24),Z124,IF(AND(B20=45,G31=60),Z191,IF(AND(B50=17,G3=42),Z147,IF(AND(B11=7,G3=6),Z125,IF(AND(B31=18,G3=24),Z60,IF(AND(B21=28,G3=78),Z176,IF(AND(B51=48,G9=28),Z161,IF(AND(B42=48,G3=79),Z199,IF(AND(B9=13,G3=78),Z89,IF(AND(B26=34,G21=79),Z195,IF(AND(B44=7,G3=4),Z149,IF(AND(B40=37,G3=27),Z102,IF(AND(B42=34,G7=75),Z169,IF(AND(B9=18,G3=51),Z107,IF(AND(B36=13,G3=81),Z97,IF(AND(B36=28,G3=6),Z140,IF(AND(B5=36,G3=59),Z157,
IF(AND(B35=37,G43=48),Z198,63))))))))))))))))))))
i want to be able to fill this down so each value steps by 13
so b44 =b57 g3=g16 and so on
it would be helpful if the sheet name could be added to the front of each cell every 15th row
so eg rows 1-14 would be for example sheet "planning outlook 2014 q1
then 15 to 28 planning outlook 2014 q2
,i believe concatenate or is it indirect? will do this
i have a list of sheet names in another workbook would it help if they were in the same workbook?
if this formula could be simplified that would help
secondly
this workbook will be shared by 25 users on a server will that be a problem?
thirdly
i would like to color any row where the value of the corresponing z value is within 12.5 % of the g value and plus or minus 2% of the b value green
if the b value is over 18% of the z value amber
in the g value is less than 16% of the g value red


i need this done asap as my boss wants this working by tomorrow
no vba as i dont understand it
thanks in advance for your help