Changing of selected font color to red inside a cell

rajani

New Member
Hi Everyone,

Could you please help me changing of selected font color inside a cell. Selection of words/ characters is depends on the user wants to color.

Ex, "John Peter" i wanted to color only "er" which is at the end
"Dave Smith is a corporate trainer" color only "a corporate"

Kind Regards,
RN
 

Peter_SSs

MrExcel MVP, Moderator
Perhaps you haven't given enough information, but based on what you have said ..
Just select the cell and then select the relevant text in the formula bar and apply the font colour you want.
 

rajani

New Member
Hi NimishK,

Thank you for the reply.

The code will be helpful if I have search string. But my problem is all the users will look into the cells and change the font color as and when applicable.

Thanks,
RN
 

rajani

New Member
Hi Peter_SSs,

Thank you for the reply.

Currently we are following the same way as suggested by you. By this method it kills huge amount of time, hence requesting for help.

Thanks,
RN
 

rajani

New Member
We are using manual method to change the colors of selected texts and the tedious task is every time we will be using the drop down of the font color section and change the font color as applicable.

Please see the example screen shot below for your reference.

 

Peter_SSs

MrExcel MVP, Moderator
.. we will be using the drop down of the font color section and change the font color as applicable.
I'm not looking at your sheet so I don't know exactly what that means.


Please see the example screen shot below for your reference.

As you have no doubt noticed, we cannot see an image that is on your computer. My signature block below has a link with suggestions for showing small screen shots. Alternatively you could upload an image to a file-share site and provide a link here. The disadvantage of the second option is that we cannot copy from an image to test with if the image you are showing is of sample data.
 

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top