Excel formatting/macro ?

Discussion in 'OT Technology' started by dissonance, Feb 23, 2007.

  1. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    I use a spreadsheet at work to keep track of a backlog. I was wanting to have Excel automatically add a specific background color to cells when they contain content. Anyone know how or if possible?
     
  2. negative zero

    negative zero New Member

    Joined:
    Oct 27, 2003
    Messages:
    6,328
    Likes Received:
    0
    Location:
    the Watchtower
    Conditional Formatting.
     
  3. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
  4. Zak8022

    Zak8022 New Member

    Joined:
    Apr 16, 2004
    Messages:
    4,012
    Likes Received:
    0
    Location:
    Maryland
  5. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    okay, I understand how to use the basic functions of that with one cell, but what if I need for it to add color to, for example...

    If data is entered into cell M1 then apply color to cells A1 - I1 and M1 (A1 - I1 have content in them at all times)
     
  6. Zak8022

    Zak8022 New Member

    Joined:
    Apr 16, 2004
    Messages:
    4,012
    Likes Received:
    0
    Location:
    Maryland
    I'm not sure i'm understanding you correctly...

    If the desired conditions are the same for all the above mentioned cells... then you can copy, and paste special (Edit -> Paste Special -> Formats). This will paste only the formatting (in this case conditional formating) to the destination cells.


    Now, if you are trying to color cells other than the one that has the dependent variable... i don't know how to do that. To my knowledge, there isnt a COLOR function... it may be available in VBA, but i'm very out of practice as far as thats concerened.
     
  7. negative zero

    negative zero New Member

    Joined:
    Oct 27, 2003
    Messages:
    6,328
    Likes Received:
    0
    Location:
    the Watchtower
    Agree with Zak. There may be a way to do it with VB.

    You can always ask in the mrexcel forums.
     
  8. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    that is what I am trying to get
     
  9. dissonance

    dissonance reset OT Supporter

    Joined:
    May 23, 2006
    Messages:
    5,652
    Likes Received:
    1
    Location:
    KS
    thanks for the excel forum suggestion, I found it on there....

    I highlight the row and go to conditional formatting, then use "formula is" and =COUNTA($L2)=1
     
  10. Zak8022

    Zak8022 New Member

    Joined:
    Apr 16, 2004
    Messages:
    4,012
    Likes Received:
    0
    Location:
    Maryland
    Ah yes... sounds right. I dont think i've ever done conditional formats using the Formula part of it. Guess i never did anything that advanced.

    Glad you figured it out!
     

Share This Page