Community› The Bump Message Boards› Eco-Friendly Family
Eco-Friendly Family
New Discussion

Any Excel Gurus out there?? quick, help!

marbear81marbear81
in Eco-Friendly Family
is it possible to shade half a cell? my boss is making me do this chart where you show completion.. so if something is 100% complete, I am just shading the entire cell.. but what do I do for 50% complete?? any ideas? TIA
Lilypie Premature Baby tickers
Report Reply to Post

Re: Any Excel Gurus out there?? quick, help!

  • papagenapapagena member
    A lighter color than the fully completed.  Don't think there's any way to shade 1/2 a cell.  You can outline them, if you want.
    Warning No formatter is installed for the format bbhtml
    Report Reply
  • Loading the player...
  • marbear81marbear81

    imageiluvmadbiker:
    maybe you could split the cell and then shade one of the two? no other ideas, sorry.

    this I could do.... hmm.. how do you split a cell? it would be right in the middle....

    Lilypie Premature Baby tickers
    Report Reply
  • marbear81marbear81
    PS - I hate hate hate hate hate excel ;-)
    Lilypie Premature Baby tickers
    Report Reply
  • ChemtchrChemtchr
    I don't think so, but you can shade it a lighter color, like if red is complete you could shade it pink for partially complete.
    Report Reply
  • papagenapapagena member

    imagemarbear81:
    PS - I hate hate hate hate hate excel ;-)

    :( This makes me sad.... I pph Excell (not the new version - can't figure out where anything is in that one...)

    Warning No formatter is installed for the format bbhtml
    Report Reply
  • marbear81marbear81
    imagepapagena:

    imagemarbear81:
    PS - I hate hate hate hate hate excel ;-)

    :( This makes me sad.... I pph Excell (not the new version - can't figure out where anything is in that one...)

    opposites attract! :-P

    what if I take a crayon and just color in half a cell and then scan it.... LOL

    Lilypie Premature Baby tickers
    Report Reply
  • clayswifeclayswife

    You can't really split cells (that I know of), but you CAN merge them.  So maybe merge two cells (select both, right click, alignment, merge) for 100% and then leave them be for 50%

    Is this your "special" assignment?? lol

    I usually love excel too... sorry you hate it :(

    DS 06.26.08 DD 10.23.10
    imageimage
    Report Reply
  • Lotte134Lotte134
    imagepapagena:

    imagemarbear81:
    PS - I hate hate hate hate hate excel ;-)

    :( This makes me sad.... I pph Excell (not the new version - can't figure out where anything is in that one...)

    Me too - Excel and I are BFF.  It truly makes me happy.  When I was getting married my staff used to ask my daily how many Excel spreadsheets I had going for the wedding - they knew my way too well.

    AlternaTickers - Cool, free Web tickersAlternaTickers - Cool, free Web tickers
    Report Reply
  • jen5-03jen5-03 member

    We do red/yellow/green for status reports. Is that an option?

    Or maybe do a pattern shading for 50%?

     You can also use Conditional Formatting to apply the colors, so you can just type your value in the cell and let it do the colors for you. This is good if you think you might want to change the colors/patterns later.

    - Jena
    image
    Report Reply
  • marbear81marbear81
    imageclayswife:

    You can't really split cells (that I know of), but you CAN merge them.  So maybe merge two cells (select both, right click, alignment, merge) for 100% and then leave them be for 50%

    Is this your "special" assignment?? lol

    I usually love excel too... sorry you hate it :(

    lol yah! it's been my special assignment ALL.DARN.DAY!!!! (sigh)

    Lilypie Premature Baby tickers
    Report Reply
This discussion has been closed.
Choose Another Board
Search Boards
"
"