1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel 2013 Help needed with Conditional Format

Discussion in 'Business Applications' started by pcatrocity, Jan 13, 2014.

Thread Status:
Not open for further replies.
Advertisement
  1. pcatrocity

    pcatrocity Thread Starter

    Joined:
    Feb 8, 2010
    Messages:
    402
    Hopefully this can be done easily.

    Column D is my bank balance and I don't want everyone seeing it. Especially my wife who tends to spend more at the store if she sees it while I check it
    .
    How can I keep only the last 4 digits visible?
    549.67 would only show
    549.67 until I highlight it with mouse.
    My wife only has one allergy. Money !
     
  2. pcatrocity

    pcatrocity Thread Starter

    Joined:
    Feb 8, 2010
    Messages:
    402
    Is this anywhere close? Where would I put it?


    font color=Automatic
    =If>4 digits(left digits=White)




    or would it be something like
    font color=White(last 4 digits=Automatic) ?
     
  3. pcatrocity

    pcatrocity Thread Starter

    Joined:
    Feb 8, 2010
    Messages:
    402
    This lame solution works in way but not really the method I'm looking for. Column D is Balance.
    I filled in cells A1:d1 with med blue
    Made font in column D White
    Made font in D1 light blue
    D1=D* (whatever the last Balance is)


    Why does using a capital D in A1:d1 produce A1:D1
     

    Attached Files:

  4. pcatrocity

    pcatrocity Thread Starter

    Joined:
    Feb 8, 2010
    Messages:
    402
    Narrowing the column hides the balance also but, it's not the result I'm looking for.
    When my wife sees $549.67 it means there is only $9.67 to spend before overdraft fees. Not $549.67 because she never had an interest in math.
    But if she sees a blank space or ##### it means that she's rich!
    So is it possible to have a white font in cells with the last 4 digits being a different color?
    Thank you
     
  5. pcatrocity

    pcatrocity Thread Starter

    Joined:
    Feb 8, 2010
    Messages:
    402
  6. CodeLexicon

    CodeLexicon

    Joined:
    Oct 15, 2013
    Messages:
    503
    I don't think there is a way to do it with conditional formatting.


    The example I attach is a drop down selector at the top which shows the actual balance (hidden column "Gross") or your preferred "Balance" figure showing only the last 4 digits.


    I show the same sheet protected and unprotected.


    I think you have to ask yourself whether this is actually the answer to your financial conundrum though ... ;-)
     

    Attached Files:

  7. pcatrocity

    pcatrocity Thread Starter

    Joined:
    Feb 8, 2010
    Messages:
    402
    Beautiful ! But how did you do it because I couldn't see any formulas.
    I'll keep this set at Balance so nobody can just walk up behind me and glance over my shoulder. So this should be okay if I learn what you did.
    Thank you
    Ron
     
  8. CodeLexicon

    CodeLexicon

    Joined:
    Oct 15, 2013
    Messages:
    503
    Here's the same thing with some notes
     

    Attached Files:

  9. pcatrocity

    pcatrocity Thread Starter

    Joined:
    Feb 8, 2010
    Messages:
    402
    Thank you very much for your help and clarification.
     
  10. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    It's correct you can't do this with conditional formatting. You can't obfuscate only portions, or certain characters, of a cell. You could do this by obfuscating the entire column, like formatting the text font color as white, then use a secondary column with a formula, maybe something like =RIGHT(TEXT(ROUND(A2,2),"0.00"),5)
    (used 5 instead of 4 to account for the decimal)

    If you want it as a number just add a double dash -- right after the = sign.
     
  11. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1117448

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice