This question is a bit complicated, so I am going to do my best to clarify my goal.

The contents of Cell B2 are a concatenation of cell E3 and a calculation of C2-D2, with brackets added in via simple concatenation.
Final appearance B2 = "402 [+10]"

I want to format the "[+10]" portion of the cell based on the calculation of C2-D2.
- If C2-D2>0, font color should be RED
- If C2-D2<0=, Font Color should be GREEN.
- If C2-D2>50 or C2-D2<-40, BOLD

The "402" portion of the cell should stay Black.

Any help would be GREATLY appreciated!!

Shannon T.