You cannot use normal functions to extract formatting ( at least not with XL2010)
OTOH using the little known GET.CELL hidden macro, the solution is attached ( value between parenthesis is the same as a negative value)
( the macro is embedded into Excel itself, you don't have to worry about it. Just keep saving as xlsm)