Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

NEGATIVE NUMBERS

Discussion in 'Information Technology' started by Contracto, Jul 28, 2006.

  1. Contracto

    Contracto
    Expand Collapse
    Guest

    I am using conditional formatting in Access and am trying to format by fill
    colour three separate conditions which are based on the sum result of two
    other cells. First: greater than 10 (Green); second: between 9 and minus 5
    (Red); third: less than minus 5). Can anybody assist as I find only two of
    the colour formats work?

    Many thanks
    Steve
     
  2. Loading...

    Similar Threads Forum Date
    1984 Anti-Sikh Riots: Victim Accuses Police of Negative Role History of Sikhism Jul 3, 2010
    What Religion Embraces Both The Positive And Negative Aspects In Life? Sikh Sikhi Sikhism Dec 19, 2009
    10 Deadly Sins of Negative Thinking Inspirational Stories Jul 22, 2009
    Dalai Lama: Negative Emotions Spiritual Articles Mar 6, 2007
    Avoiding Negative Vibrations Spiritual Articles Oct 19, 2005

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I tried it, and it works up to 3 of them. Three is the maximum for
    conditional formatting. Make sure that you've entered the expressions
    correctly.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Contracto" <Contracto@discussions.microsoft.com> wrote in message
    news:1CBE2734-1218-4A98-8633-43B1E35E024B@microsoft.com...
    > I am using conditional formatting in Access and am trying to format by

    fill
    > colour three separate conditions which are based on the sum result of two
    > other cells. First: greater than 10 (Green); second: between 9 and minus 5
    > (Red); third: less than minus 5). Can anybody assist as I find only two of
    > the colour formats work?
    >
    > Many thanks
    > Steve
     
  4. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Be aware that conditional formating DOES NOT give you an error message
    if something is wrong with the statement. It just doesn't work.
     
  5. Contracto

    Contracto
    Expand Collapse
    Guest

    Arvin

    The content of the text cell in the form is the sum of two other date/time
    formatted cells, therefore in certain cases it returns a negative number. I
    am trying to "flash-up" specific periods as follows:

    Greater than 10 days = green
    Between 9 and -4 days = yellow
    Less than -5 days = red.

    Conditinal formatting registers the first two, but any negative numbers,
    such as -15 are colour coded green and not red.

    Any suggestions please would be most welcome.

    Regards
    Steve Coleman

    "Arvin Meyer [MVP]" wrote:

    > I tried it, and it works up to 3 of them. Three is the maximum for
    > conditional formatting. Make sure that you've entered the expressions
    > correctly.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "Contracto" <Contracto@discussions.microsoft.com> wrote in message
    > news:1CBE2734-1218-4A98-8633-43B1E35E024B@microsoft.com...
    > > I am using conditional formatting in Access and am trying to format by

    > fill
    > > colour three separate conditions which are based on the sum result of two
    > > other cells. First: greater than 10 (Green); second: between 9 and minus 5
    > > (Red); third: less than minus 5). Can anybody assist as I find only two of
    > > the colour formats work?
    > >
    > > Many thanks
    > > Steve

    >
    >
    >
     
  6. Kernow Girl

    Kernow Girl
    Expand Collapse
    Guest

    Hi Contracto - check the order you have the conditions in. I have 9 to -4
    first, -5 second and greater than 10 last and it seems to work. However;
    isn't -4 less than -5? Should it be 9 to -5 and then less than or equal to
    -4? HTH - yours Dika

    "Contracto" wrote:

    > Arvin
    >
    > The content of the text cell in the form is the sum of two other date/time
    > formatted cells, therefore in certain cases it returns a negative number. I
    > am trying to "flash-up" specific periods as follows:
    >
    > Greater than 10 days = green
    > Between 9 and -4 days = yellow
    > Less than -5 days = red.
    >
    > Conditinal formatting registers the first two, but any negative numbers,
    > such as -15 are colour coded green and not red.
    >
    > Any suggestions please would be most welcome.
    >
    > Regards
    > Steve Coleman
    >
    > "Arvin Meyer [MVP]" wrote:
    >
    > > I tried it, and it works up to 3 of them. Three is the maximum for
    > > conditional formatting. Make sure that you've entered the expressions
    > > correctly.
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > > "Contracto" <Contracto@discussions.microsoft.com> wrote in message
    > > news:1CBE2734-1218-4A98-8633-43B1E35E024B@microsoft.com...
    > > > I am using conditional formatting in Access and am trying to format by

    > > fill
    > > > colour three separate conditions which are based on the sum result of two
    > > > other cells. First: greater than 10 (Green); second: between 9 and minus 5
    > > > (Red); third: less than minus 5). Can anybody assist as I find only two of
    > > > the colour formats work?
    > > >
    > > > Many thanks
    > > > Steve

    > >
    > >
    > >
     

Share This Page