Windows 8 and 8.1 Forums

Excel 2013 Help needed with a Conditional Format

  1. #1

    Excel 2013 Help needed with a Conditional Format

    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 System SpecsSystem Spec

  2. #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 by pcRat; 13 Jan 2014 at 18:03.
      My System SpecsSystem Spec

  3. #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 A11?
      My System SpecsSystem Spec

  4. #4

    Possible or Impossible ? To show the last 4 places of a cell's number in a different color.Click image for larger version
      My System SpecsSystem Spec

  5. #5

    Click image for larger version
      My System SpecsSystem Spec

  6. #6

    Posts : 55
    Windows 7 Pro plus Windows 8.1 Pro VM

    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 System SpecsSystem Spec

  7. #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
      My System SpecsSystem Spec

Excel 2013 Help needed with a Conditional Format

Similar Threads
Thread Forum
New Excel 2013 BI stability and usability improvements
Windows 8 News
Excel 2013 Won't Allow Me to Select a Printer
Running Windows 8.1 and Office 2013. Have a Canon 4370dw Laser Printer connected to my desktop via USB. Have a Brother MFC-J475dw inkjet connected wirelessly to the network. Default printer is the Canon. Here's the problem: Word - In print dialogue, I can choose to print from either the Brother...
Drivers & Hardware
Changing cell height in excel 2013
Hello, I am beginning to suspect this is not possible. What I want is to have a column with "notes" in which the cells (and the rows with them) expand downwards to accommodate additional text. Can this be done? All the online tutorials just seem to think people want lots of nice additional...
General Support
excel 2013 problem on win8
Good times of the day :), I have excel 2013 installed on win8 and i have several excel files on the internet that i try to open simultaneously and here is the problem: sometimes when one file is open and i try to open another it doesn't open until I close the first one. Does anyone have a clue or...
Software and Apps
Excel Chart Rename Cell help needed
I should probably quit trying to do new things with Excel but everything opens a new door. I finally learned to make a chart. Change the title. Even rename Series 1 , 2 & 3 at bottom.:dinesh: BUT, for the life of me I cannot figure out how to rename the cells labeled 1 , 2 , 3 , 4 & 5 at the...
Software and Apps
Windows 8 Excel 2013 Thousands Separator India
Hello, I stay in India. I was using Windows 7 and Office 2010. In the regional settings in Windows 7, I had selected "English (India)" and therefore, Excel 2010 was putting the thousands' separator as per the Indian Rules. In Windows 8 also, I've selected "English (India)" in my regional...
Software and Apps
Sharing Violation in Excel 2013
Does anyone know why when I try to save some Spreadsheets in Excel 2013 I get a message saying there is a sharing violation and I have to save the file under a different name. I am the only person using the computer and the Excel program. Thanks in advance Peter
Software and Apps

Eight Forums Android App Eight Forums IOS App Follow us on Facebook