How to highlight selected text within excel

by

This is the basic principle, I assume that customizing this code is not what you are asking (as no details about this were provided):

 Sub Colors()

 With Range("A1")
    .Value = "Test"
    .Characters(2, 2).Font.Color = vbGreen
 End With

 End Sub

Small description although it speaks quite for itself: the first “2” refers to the first character that needs to be colored, the second “2” refers to the length.

More Related Contents:

  1. Sequence of numbers based on start and end value of 2 cells [closed]
  2. How do I find the last column with data?
  3. Better way to find last used row
  4. How to insert a picture into Excel at a specified cell position with VBA
  5. 2 Dimensional array from range [closed]
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. How can I create a calendar input in VBA Excel?
  9. Using Google Chrome in Selenium VBA (Installation Steps)
  10. Dir() function not working in Mac Excel 2011 VBA
  11. Merge values of column B based on common values on column A
  12. How to use workbook.saveas with automatic Overwrite
  13. How to import a table from web page (with “div class”) to excel?
  14. Range limit conundrum
  15. How do you run a .exe with parameters using vba’s shell()?
  16. Excel VBA – Range.Copy transpose paste
  17. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  18. Saving a Excel File into .txt format without quotes
  19. Passing variable from Form to Module in VBA
  20. How to give a time delay of less than one second in excel vba?
  21. Changing the date format to yyyy-mm-dd
  22. Delete all duplicate rows Excel vba
  23. excel to pdf ignores print area and calls printer
  24. Select Newest Record and Create New Table of Unique Values in Excel
  25. Are ActiveX Controls Disabled?
  26. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  27. VBA copy rows that meet criteria to another sheet
  28. VBA Dialog box to select range in different workbook
  29. excel vba how to copy the value of multiple non-contiguous ranges into an array
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment