Search results

  1. S

    Only 3 Conditional formats? Help!

    I'd thought I'd seen something somewhere, and looked around... I found this on microsoft: Number of conditions on a range is no longer limited by number. In Excel 2003, you could create conditional formatting rules with three conditions. In Excel 2007, you are no longer limited by number; you...
  2. S

    Only 3 Conditional formats? Help!

    No success so far :( Thank you boblarson, I was 2 paragraphs into reading that article and saw "The three-condition limit can be overcome by using VBA code" and I was about ready to come back here and post a big "KA-CHING!" for you. But, his method of overcoming wasn't all I envisioned it might...
  3. S

    Only 3 Conditional formats? Help!

    Conditional Formatting (revisited) Ok, guess I'm out of luck using a continuous form. I can display the same data via a Data Access Page, set to display all records. Can I reference individual fields in each row and set attributes depending on field value in a DAP? How does one attach a...
  4. S

    Only 3 Conditional formats? Help!

    I'm pulling data from an external (Advantage) database via ODBC and am trying to present an updatable form to the users. All was well until I was asked to color code each records "status" in my continuous form to match the colors used in the retail software we use. Conditional formatting would...
Back
Top Bottom