+ Reply to Thread
Results 1 to 4 of 4

How to change font for cells in existing excel sheet but only for further inputs to it?

  1. #1
    Registered User
    Join Date
    09-27-2010
    Location
    kbk
    MS-Off Ver
    Excel 2007
    Posts
    8

    How to change font for cells in existing excel sheet but only for further inputs to it?

    I received an excel sheet half-filled by my friend. I want to add my inputs to it. However, I want it to look distinctive. Since there are many such cells, selecting them and changing the format is tedious and also prone to make mistakes.

    Is there a setting in excel that allows me to change the format for all the empty cells once for all?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,420

    Re: How to change font for cells in existing excel sheet but only for further inputs to it

    You should select all the cells which are filled in and those (blanks) that you expect to fill in, and then press the F5 (GoTo) key. On the pop-up you should click on Special, and then on Blanks and click OK. Then you could apply the format that you wish (e.g. yellow background), and this will be applied only to the blank cells that are selected.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    09-27-2010
    Location
    kbk
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: How to change font for cells in existing excel sheet but only for further inputs to it

    Thanks, Pete. It did help. I am extending this question to a further level. In some of my cells, he has input "?" symbol which also needs to be filled by me. Is there a possibility to add that to my selection apart from blank cells?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    8,905

    Re: How to change font for cells in existing excel sheet but only for further inputs to it

    After employing Pete's solution you could leave all of the cells selected, whether filled with values or question marks or unfilled, and then apply conditional formatting with the rule > Format only cells that contain > specific text > containing > ?
    Providing that you leave the ? in the cell after filling, the cell will remain highlighted.
    If the ? is removed then you would have to manually highlight the cell, however, since the cursor will be inside the cell after filling, there should be less chance of a mistake.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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