Thread: Format text string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saintsman Saintsman is offline
external usenet poster
  
Posts: 81
Default Format text string
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
Reply With QuoteReply With Quote