Formatting in a formula

P

Pat Canton

I am trying to format only a certain part of a formula...

Formula is :

=IF(ISBLANK('Cabinet Information'!D21),"Stain","Stain - "&'Cabinet
Information'!D21)

I don't want to bold Stain, only what comes after it - 'Cabinet
Information'!D21).
Is this possible from inside a formula?

Thanks in advance,

Pat Canton
 
G

Gary''s Student

Not within a formula. You would need to copy and then pastespecial/values and
then apply the formats
 
D

Dylan @ UAFC

sure if this only driven off a 21 lines of data
you could possilbe go one by one on the conditional
formating and go new rule, there is somewher in there
were it ill let type specific text and it auto formate that
text or text in the range disirered
 
Top