Formatting in a formula

  • Thread starter Thread starter Pat Canton
  • Start date Start date
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
 
Not within a formula. You would need to copy and then pastespecial/values and
then apply the formats
 
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
 
Back
Top