Closed Thread
Results 1 to 7 of 7

can I make Blank cells a color?

  1. #1
    Frank
    Guest

    can I make Blank cells a color?

    Hi,
    excel 2003, is their a filter, or way, to have a column formatted so that if
    thier i no info in the cell it is distinguishable immediately, like a color
    maybe? Just give me the crumbs and I will be happy to do the research and
    learn.
    Thanks
    Frank



  2. #2
    Dave Peterson
    Guest

    Re: can I make Blank cells a color?

    Look at Format|Conditional formatting

    spoiler alert....

    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    ..
    Select the column (Say column C).
    with C1 the activecell in the selection
    format|conditional formatting
    formula is: =C1=""
    click on the Format... button
    choose the format you want
    (I'd use the pattern tab and a nice color)


    Frank wrote:
    >
    > Hi,
    > excel 2003, is their a filter, or way, to have a column formatted so that if
    > thier i no info in the cell it is distinguishable immediately, like a color
    > maybe? Just give me the crumbs and I will be happy to do the research and
    > learn.
    > Thanks
    > Frank


    --

    Dave Peterson

  3. #3
    Max
    Guest

    Re: can I make Blank cells a color?

    One way via conditional formatting ..

    Try this:
    Press CTRL+A (this selects the entire sheet)

    Click Format > Conditional Formatting

    Under Condition 1, set it as:
    Formula is| =NOT(ISBLANK(A1))
    Click Format button > Patterns tab > Light green? > OK

    Click OK at the main dialog

    Now test it out, enter anything in any cell on the sheet
    The cell will be filled with the light green color
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --
    "Frank" <stratster68@IHATESPAMworldnet.att.net> wrote in message
    news:e7i425kuFHA.2512@TK2MSFTNGP10.phx.gbl...
    > Hi,
    > excel 2003, is their a filter, or way, to have a column formatted so that

    if
    > thier i no info in the cell it is distinguishable immediately, like a

    color
    > maybe? Just give me the crumbs and I will be happy to do the research and
    > learn.
    > Thanks
    > Frank
    >
    >




  4. #4
    Max
    Guest

    Re: can I make Blank cells a color?

    Oops ! Had it the other way round ..
    Just change the cond format formula to: =ISBLANK(A1)
    if you want to fill blank cells (as per post)

    Now when you enter anything in any cell,
    the cell will become "colourless" (i.e. the default "no fill" color)
    (or it'll just assume the normal fill color applied, if done)
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



  5. #5
    David McRitchie
    Guest

    Re: can I make Blank cells a color?

    Another potential problem,
    you would want to select cell A1 before using Ctrl+A
    so that A1 is the activecell that the formula is based on. Without
    that bit of information the Original Poster will wonder why C.F. works
    great sometimes and fails at other times.
    http://www.mvps.org/dmcritchie/excel/condfmt.htm

    "Max" <demechanik@yahoo.com> wrote in message
    > Oops ! Had it the other way round ..
    > Just change the cond format formula to: =ISBLANK(A1)
    > if you want to fill blank cells (as per post)
    >
    > Now when you enter anything in any cell,
    > the cell will become "colourless" (i.e. the default "no fill" color)
    > (or it'll just assume the normal fill color applied, if done)
    > --
    > Rgds
    > Max
    > xl 97
    > ---
    > Singapore, GMT+8
    > xdemechanik
    > http://savefile.com/projects/236895
    > --
    >
    >




  6. #6
    Frank
    Guest

    Re: can I make Blank cells a color?

    Thanks so much to all of you guys and gals. This is one of the most "quick
    and understandable response" NG's I have been to. Really great!
    Frank

    "David McRitchie" <dmcritchie_xlmvp@verizon.net> wrote in message
    news:%23Li5MyluFHA.2512@TK2MSFTNGP10.phx.gbl...
    > Another potential problem,
    > you would want to select cell A1 before using Ctrl+A
    > so that A1 is the activecell that the formula is based on. Without
    > that bit of information the Original Poster will wonder why C.F. works
    > great sometimes and fails at other times.
    > http://www.mvps.org/dmcritchie/excel/condfmt.htm
    >
    > "Max" <demechanik@yahoo.com> wrote in message
    >> Oops ! Had it the other way round ..
    >> Just change the cond format formula to: =ISBLANK(A1)
    >> if you want to fill blank cells (as per post)
    >>
    >> Now when you enter anything in any cell,
    >> the cell will become "colourless" (i.e. the default "no fill" color)
    >> (or it'll just assume the normal fill color applied, if done)
    >> --
    >> Rgds
    >> Max
    >> xl 97
    >> ---
    >> Singapore, GMT+8
    >> xdemechanik
    >> http://savefile.com/projects/236895
    >> --
    >>
    >>

    >
    >




  7. #7
    Max
    Guest

    Re: can I make Blank cells a color?

    David, thanks. Good point there about ensuring
    that cell A1 is selected before using Ctrl+A

    Frank - you're welcome !
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



Closed 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