• 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.

Highlighting PART of a custom format cell

B

BigStevie1973

New Member
Hi,

I have a cell in which I have created the following custom format:

"Attended Gym "#" Times"

and this displays the number of times that I have attended the gym but my question is this: is it possible to create a custom format for the "#" part of the cell, i.e. the actual number of times I have attended the gym in order to make it stand out from the rest of the text? Any help would be greatly appreciated.

Many thanks,

Steve
 
No, not just part of the cell. Also can't color just a portion of the output from a formula, so concatenating is out. I've seen it done via VB if you really need it...but IMO, it's not. :(
 
Hi Steve ,

What you can do is , instead of using a Custom Format , either split the entire text into 3 columns , or if you have to have it in one column , insert the text using textboxes , on either side of the number , which can remain in the worksheet cell , and can be formatted to any size and any colour to make it stand out.

Narayan
 
bobhc said:
Good day Steve and welcome to the forum

If you have not already done so, please read this link it will help in the use of the forum.

http://chandoo.org/forum/forums/new-users-please-start-here.14/

Do you mean as per the upload.

.
Click to expand...
bobhc, thanks but the hash symbol displays a figure calculated from a formula so unfortunately your suggestion wouldn't work, I think as Luke M stated, it is feasible with VB but not really worth the hassle and in this case it was just my OCD getting the better of me so probably not worth it!! Thanks for all your suggestions though.

Steve
 
You must log in or register to reply here.
Back
Top