Formatting a Cell Reference with a Formula
To expand on Sandy's answer, a formula in conditional formatting can format
a cell, but not part of a cell.
A cell which contains text can have a format applied to part of the text,
but that can't be done if the text contains a formula, rather than just
text.
--
David Biddulph
"Sandy Mann" wrote in message
...
No, I'm afraid that formulas cannot format cells.
"CC" wrote in message
...
Is there a way to make parts of a formula bold and or italic?
"Sandy Mann" wrote:
Replace you reference $K9 with:
TEXT($K9,"$#,##0.00")
and remove the "$" before it.
"CC" wrote in message
...
I have tried to do this and cannot, but my formula is a concatenation
of
up
to 7 fields, including both numbers and text. Although I've formatted
the
cells that the concatenated formula is pulling, the dollar amounts are
not
being formatted within the concatenated formula result. Is there a
way
to
format dollars within a concatenation formula?
My formula reads as:
=IF(ISBLANK($H9),"",CONCATENATE($H9," - ","(",I9,")"," ",$J9,"
","$",$K9,"
",$L9," "," ","(",$M9,")"))
I would like the dollar field K9 to show as dollars with dollar sign
and
appriopriate commas.
|