=IF('DT Growth EW'!H8<-7%,'DT Growth EW'!E8," ")&IF('DT Growth EW'!H8<-7%,(TEXT('DT Growth EW'!G8,"0.0%"))," ")
I am trying to get a space between E8 and G8, it returns a value as such "CMG-29.3%"
I would like it to look like "CMG -29.3%" with the -29.3% in red and if that was to be positive then in black
thanks