+ Reply to Thread
Results 1 to 6 of 6

How to color-fill blank cells, then once data is entered cell is no-fill

  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    How to color-fill blank cells, then once data is entered cell is no-fill

    I've been trying to look online but none of the tuts are really helping me. I am using Microsoft Excel 2010

    I'm trying to format my spreadsheet. I have a Gross Rate column and a Net Rate column (about 100 rows).

    I want to format the spreadsheet so that if there is nothing at all entered in the cells, the cell will be filled with a color. As soon as any data is typed into that cell, I want the cell's fill to be blank (so white).

    I've seen this on other spreadsheets but do not know how to accomplish this.

    Thank you very much

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,980

    Re: How to color-fill blank cells, then once data is entered cell is no-fill

    You can do this with Conditional Formatting.

    Your profile says you have 2003, I cant remember exactly where CF is in that ver. but it should be under formatting (i think)

    You need to go into CF and select "format cell contents" and select "blank" if that option is there
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-14-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: How to color-fill blank cells, then once data is entered cell is no-fill

    Whoops havent updated this profile in a long time....I'm using 2010 at work

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,980

    Re: How to color-fill blank cells, then once data is entered cell is no-fill

    ok same thing...

    select the range you want to apply CF to
    find CF on the Home tab - styles
    select New Rule
    select "format cells that contain"
    on the pull-down, select BLANKS

  5. #5
    Registered User
    Join Date
    07-14-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: How to color-fill blank cells, then once data is entered cell is no-fill

    Quote Originally Posted by FDibbins View Post
    ok same thing...

    select the range you want to apply CF to
    find CF on the Home tab - styles
    select New Rule
    select "format cells that contain"
    on the pull-down, select BLANKS

    Got it thank you very much!!! Works fine!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,980

    Re: How to color-fill blank cells, then once data is entered cell is no-fill

    you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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