Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Coloring Cells

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    About a year ago I had to color certain cells based on certain numbers or combinations of numbers.

    Someone answered my inquiry and provided me with a formula and how to set it up.

    An example of the formula I used was:
    =SUM(IF(A7=PNAMES,ERROR*ASSIGNED))

    However, I cannot remember how to change the formula. Can someone walk me through how I can do this?

    Thank You

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    135
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Double click the cell in which the formula was entered. You will then be able to edit the formula. Alternatively you can single click the cell in which the formula was entered and then you can go to the formula bar toward the top of the screen and edit the formula there. This is assuming that the worksheet where the formula is contained is not protected.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you for your reply.

    Can you tell me what "pnames" refers to and how I can change what it refers to?

    Can you explain what "ERROR*ASSIGNED" refers to and is it something that should/can be changed?

    I am trying to add an additional number that I want to be filled in with a color. I need to be able to access the specific elements/references in the formula.

    Thanks


    _________________
    Glenn

    [ This Message was edited by: Glennm on 2002-04-09 10:10 ]

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    135
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    PNAMES and the other names mentioned in the formula refer to cells in your worksheet. To find out which cells they refer to go to Insert from your menu. Then click on Name. Then click on Define. Then select the Names which you are concerned about. When you have selected a name, look at the bottom of the pop-up window and you will see a Refers To bar. This will tell you what cells are being refereed to.

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Would you like a special code for the assignment?

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If your goal is to "color certain cells based on certain numbers or combinations of numbers" have you tried using Excel's conditional formatting feature (Format menu)?

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Gareth-

    Yes. I would appreciate a special code.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •