• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

The Bold Formula?

Harry0

Member
No real bold formula that I know of or a right to left merge, so have to do tricks which can do it. It should be doable and better in vba but this is a cheap way without VBA to do bold,italic,size,color,etc and change its things in a quick way.

If I try to explain people will say they don't get it so see attachment. If the first column changes, so if it is 1 then result is A, if it is 2 then result is B with bold/italic/etc. It uses 3 columns to do it (B,C,D).
 

Attachments

  • bold.xlsx
    35.1 KB · Views: 30
Last edited:
hi buddy...

here you go...try changing cell value in col. A..

check macro in sheet 1 module..

Cheers!!
 

Attachments

  • bold.xls
    32.5 KB · Views: 15
No need for a macro...you can use conditional formatting now to set bold/italics/font color.

Harry0, I do like the trick though of using hidden columns with extra spacing. I can think of a few ways in my files that I can use this. :awesome:
 
Back
Top