+ Reply to Thread
Results 1 to 7 of 7

Shortcut for changing the color from black font to red

  1. #1
    Registered User
    Join Date
    05-03-2017
    Location
    oslo
    MS-Off Ver
    online
    Posts
    3

    Question Shortcut for changing the color from black font to red

    Hi,

    I need some words in the excel to be in red color, so I switch back and forth from changing font color, black to red.

    I can’t seem to find a shortcut key to change from the black font color, to red.

    Is there a shortcut-key from changing back and forth fast, while typing the text?

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,277

    Re: Shortcut for changing the color from black font to red

    No. You can use [press Alt H H] then change color what ever you want.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Shortcut for changing the color from black font to red

    You can put these in your personal macro workbook and assign keyboard shortcuts to them, i.e. ctrl+shift+R for red and ctrl+shift+B for black: (basically, create your own keyboard shortcut to do what you want)

    For red:
    Please Login or Register  to view this content.
    For black:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-03-2017
    Location
    oslo
    MS-Off Ver
    online
    Posts
    3

    Re: Shortcut for changing the color from black font to red

    And how exactly do I do that? A step by step would be very much appreciated, cuz im at a beginner lever here

  5. #5
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Shortcut for changing the color from black font to red

    1. Press alt+F11 to open the VBA editor.
    2. On the left-hand side (if there is no left-hand side press ctrl-R), right click on “personal.xlsb”.
    3. Click Insert --> Module, copy the Red Font macro and paste it in the module.
    4. Save and close the VBA editor.
    5. On your excel ribbon, click View --> Macros.
    6. Click once on Red_Font and then click Options.
    7. By “Shortcut Key” press Shift+R, then click OK, then cancel.
    8. Now any cell you select you can press ctrl+shift+R to turn the font red!

    (The black font macro you don't really need because the font is black by default anyway.)

  6. #6
    Registered User
    Join Date
    05-03-2017
    Location
    oslo
    MS-Off Ver
    online
    Posts
    3

    Re: Shortcut for changing the color from black font to red

    But I am using windows 7, and an online shared worksheet excel i.e docs.google.com/spreadsheet/excel

    How do I do that in that?

  7. #7
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Shortcut for changing the color from black font to red

    It's a google docs sheet? Then you shouldn't be posting in an excel forum, you should post in a google forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to automatically activate a macro when the font color in a cell changes to black
    By ainon ithnain in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2014, 03:52 AM
  2. Changing all blue color numbers/texts to black color in cells...
    By dhyun3 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-05-2012, 10:17 AM
  3. Change the font color to black in the entire workbook
    By fatalcore in forum Excel General
    Replies: 2
    Last Post: 03-31-2011, 02:30 AM
  4. Single shortcut for changing color font within a cell
    By DaLearner in forum Excel General
    Replies: 3
    Last Post: 10-15-2009, 11:37 AM
  5. Replies: 5
    Last Post: 07-27-2009, 03:46 AM
  6. getting font color to stay black!
    By buckfoston in forum Excel General
    Replies: 1
    Last Post: 06-02-2006, 05:45 PM
  7. Fill Color and Font Color stay Black and White
    By Hors Categorie in forum Excel General
    Replies: 1
    Last Post: 05-10-2005, 07:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1