Excel Conditional formatting with this bastard of an IF statement

If someone could please show me how to write this CONDITIONAL IF statement out correctly that would be awesome.

IF(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,7)="3-5" & (OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,4)>5 {THEN FILL CELL RED} {ELSE NO FILL}