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.

Excel Linking an IF statement with a Fill Color

Discussion in 'Business Applications' started by Officedude, Sep 13, 2005.

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

    Officedude Thread Starter

    Joined:
    Sep 13, 2005
    Messages:
    3
    HI, I am really trying to link an IF statetment if a cell is shadded. Once cell (E44) is shadded, i need Cell (T33) to be linked to cell (B3). If the cell has not been shaded then cell (T33) is to be left blank or with a - in it. I just need to know how to link a cell using a fill color (dont care if its all of them) if its even posable. I tryed using cell color but hasnt worked yet.

    Thanks in advance.

    Officedude
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,731
  3. Officedude

    Officedude Thread Starter

    Joined:
    Sep 13, 2005
    Messages:
    3
    I've tryed this, however, I can't figure out how to nest this conditional format within an IF Statement. What i need is if cell "A" is filled, then cell "B" will display the contents of cell "C" so to speak. Any sugestions?
     
  4. Officedude

    Officedude Thread Starter

    Joined:
    Sep 13, 2005
    Messages:
    3
     
  5. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,731
    Sorry. I've already said: Formulas and colors don't mix.

    You could potentially use VBA, but you will not find a formula that will accomplish this task. They don't exist. The only other thing I can imagine is that cell B ALWAYS contains the contents of cell C, but is conditionally formatted as white font if cell A is empty.
     
  6. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,731
    Looks like you could possibly use this UDF:
    http://vbaexpress.com/kb/getarticle.php?kb_id=190

    And then combine that formula with yours. Something like this in column b:
    =if(ConditionalColor(A1,"interior")="color",C1,"")

    (where color is the color to match)
     
  7. 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/398658