• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Solved Excel 2013 Help needed with a Conditional Format


pcRat

New Member
Power User
#1
Maybe this can't be done.

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 figure how much she can spend.

What I'm trying to do is to keep only the last 4 digits visible. 549.67 would only show 549.67 until I drag the mouse over it with left button down.

My wife only has one allergy. Money
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

pcRat

New Member
Power User
#2
Is this anywhere close?

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


or smaybe something like
font color=White(last 4 digits=Automatic) ?
 
Last edited:

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

pcRat

New Member
Power User
#3
It's important that this acct shows a balance of $9.99 max even if there is $99999.99 in it.

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
Except for D1 which font is light blue
D1=D* (whatever the last Balance is) shows lightly

Why does A1: D1 without a space produce A1:D1?
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

pcRat

New Member
Power User
#4
Possible or Impossible ? To show the last 4 places of a cell's number in a different color. -Bump Up Arrow.png
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

DaddyG

Member
Member
Posts
54
#6
Is this solution acceptable ? You hide the column that shows your real bank balance. Let's say that column is AK. You have another column which pretends to be your bank balance. Let's say that column is AD. In each cell in column AD you have a formula such as .... =RIGHT($AK1,4). The number 1 in this example refers to the line of the first entry in the AK column and the number 4 refers to the figures to be shown (which includes the decimal point). Obviously the next entry below will be ... =RIGHT($AK2,4) and so on.
Maybe you even then password protect your spreadsheet so the hidden column can't be revealed.

I'm no expert but managed to get it working satisfactorily.
 

My Computer

System One

  • OS
    Windows 7 Pro plus Windows 8.1 Pro VM
    Computer type
    PC/Desktop
    System Manufacturer/Model
    Custom
    CPU
    i7-3770K
    Motherboard
    Gigabyte GA-Z77X-UD3H
    Memory
    16 GB x G.SKILL Ripjaws
    Graphics Card(s)
    GeForce GTX560
    Screen Resolution
    1920 x 1080
    Hard Drives
    Main - OCZ Vertex4 128 GB Solid Drive
    Sec - Hitachi Deskstar 7K1000D 1TB
    PSU
    Seasonic X-760
    Case
    Coolermaster HAF912 ATX Mid Tower
    Cooling
    Corsair Hydro Series H80 CPU water cooler
    Browser
    Firefox
    Antivirus
    Eset

pcRat

New Member
Power User
#7
=RIGHT($AK1,4) That's the ticket and it's so simple.

Thank you for the formula and simple explanation. I understand it but ... it was beyond me.

Thank you
Ron
 

My Computer

System One

  • OS
    8.1
    Computer type
    PC/Desktop
    CPU
    i7-3770K
    Motherboard
    ASRock Z77 Extreme4
    Memory
    16 GB
    Graphics Card(s)
    onboard
    Monitor(s) Displays
    17" 24"
    Hard Drives
    1 TB WD
    PSU
    550w

Users Who Are Viewing This Thread (Users: 0, Guests: 1)