Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    colour coding (xp)

    I have a subform which I am trying to set each row colour based on whait is in the status column. If "On hold" the row should be red; "In pro" the row should be yellow; and " completed" the row should be Green. I have tried the conditional formating but something went wrong.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: colour coding (xp)

    The Status field is a number (long integer). The combo box has 2 columns, of which the first (hidden) one contains the numeric ID, and the second one displays the corresponding description from the Status table. So for "On Hold", you should test for the value 1, etc. - see the Status table. And you should use Value Is, not Expression Is.

    Does that give you enough to solve the problem?

  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: colour coding (xp)

    But how do I get it to do the entire row not just the cell?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: colour coding (xp)

    Open the form in design view.
    Select all text boxes/combo boxes.
    Select Format | Conditional Formatting.
    Select Expression Is from the dropdown (yes, this time you need it)
    Enter [Status]=1 in the box next to it.
    Select red as background color and white as font color.
    Click Add >>, and repeat for the other two values.
    Click OK.

Posting Permissions

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