run conditional format formula from another cell in another worksheet

Hi,

I have a formula in 'Sheet1' cell A1 and am needing to conditionally format cells A1:AY1 in sheet '28' with this formula. The formula is too large to put into the ordinary conditional format procedure in excel so need the cells to be conditionally formatted running the formula from this other sheet which will be hidden.

I am running on excel 2003, can anyone help me to accomplish this?

Thanks

Here you go...

=AND(D$4>=VALUE(LEFT(INDEX($D$57:$AA$63,MATCH($C6,$C$57:$C$63,0),MATCH($A$13,$D$56:$AA$56,0)),FIND(""-"",INDEX($D$57:$AA$63,MATCH($C6,$C$57:$C$63,0),MATCH($A$13,$D$56:$AA$56,0)))-1)),D$4<=VALUE(MID(INDEX($D$57:$AA$63,MATCH($C6,$C$57:$C$63,0),MATCH($A$13,$D$56:$AA$56,0)),FIND(""-"",INDEX($D$57:$AA$63,MATCH($C6,$C$57:$C$63,0),MATCH($A$13,$D$56:$AA$56,0)))+1,255)))

The cell ranges in the formula relate to cells on sheet 28