LinkBack URL
About LinkBacks
I am trying to get a space between E8 and G8, it returns a value as such "CMG-29.3%"
Please Login or Register to view this content.
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
I am trying to get a space between E8 and G8, it returns a value as such "CMG-29.3%"Please Login or Register to view this content.
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
To insert a space, you'd useFormula:
Please Login or Register to view this content.
You cannot format part of the result of a formula.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Welcome to the board.
= IF('DT Growth EW'!H8<-7%, 'DT Growth EW'!E8 & TEXT('DT Growth EW'!G8," 0.0%"))I am trying to get a space between E8 and G8
Can't be done. You could use conditional formatting to make the font for the entire cell red if G8 is negative.with the -29.3% in red
Entia non sunt multiplicanda sine necessitate
Awesome thanks
You can either just concatenate a space in between
Formula:Please Login or Register to view this content.
Or bake it into your format:
Formula:Please Login or Register to view this content.
The result of a formula cannot have multiple formats. You are stuck with one color.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks