+ Reply to Thread
Results 1 to 2 of 2

Making a cell display blank (but not empty) when an adjacent cell has a value

  1. #1
    Registered User
    Join Date
    01-31-2008
    Posts
    19

    Making a cell display blank (but not empty) when an adjacent cell has a value

    Here's my next problem!

    I have the following columns:

    Qty. Each (manual) Each Total


    Typically only the 'Qty.' 'Each' and 'Total' columns will contain a value. However there are occasions where I need to enter a manual value, or modify the value calculated for 'Each' (for example Each x 90% or Each + 5.00). This edited value will be shown in 'Each (manual)' column.

    If I have a value in this column, I want the original value to not be displayed, but obviously the equation which calculates the value for 'Each' column needs to still be there as it is referenced in 'Each (manual)'.

    Does Excel have a function to hide a cell value, or can I input a command so 'Each' appears blank, by changing the text colour automatically to white (thus making the cell look empty).

    If someone can show me a way of doing this it would really help.

    Note: I still need the 'Each' column to be present, as in other rows in my table I will still have a value in the 'Each' column

    Cheers in advance, as always I will post my solution when I've sorted this one
    Last edited by cptwhite; 02-06-2008 at 06:59 AM.

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    apply conditional formatting to the cells in the EACH column, the formula checks if EACH MANUAL is not blank, and if that is the case makes the font in EACH white, something like...

    =A2<>""

+ Reply to 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