Format text string

G

Guest

I like to combine cell values within text on my reports, usually no issues
I would like to format a number so that if it is negative it is red & in
brackets
The brackets appear fine, but I cannot change the font colour
=TEXT(ROUNDUP(I8*10.764,-2),"#,##0;[RED](#,##0)")&" ft²")
Anybody able to help?

Saintsman
 
M

macropod

Hi Saintsman,

You could use:
=ROUNDUP(I8*10.764,-2)
with a custom number format:
#,##0ft²;[Red](#,##0ft²)

The advantage of doing it this way is that the result of your calculation remains numeric, despite the addition of the 'ft²'.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Cell Number Options missing 5
conditional formating with text 5
Custom Number Format for text 8
Text format - setting text colour with code 5
Changing text color within a formula??? 8
Format cells to make zeros not appear,or be invisible on screen &p 3
Can i format (colour) selective text in a cell using excel2000? 3
count number of times text appears 3

Top