Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    conditional formating (2000)

    Question - I am trying to conditional format a calculated text box with the formula =[convert]-[left] and it brings back a number. I went up to conditonal formatting and put if value is less than or equal to color red. However, it brings back red on any number. I did another text box on the same form and it works. I know this is probably very simple and any help is appreciated.

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

    Re: conditional formating (2000)

    You say "... put if value is less than or equal to color red". Less than or equal to what? You must fill in something in the box to the right of "less than or equal to".

  3. #3
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: conditional formating (2000)

    I am sorry .. if it is less or = to 72 then it brings back red.

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

    Re: conditional formating (2000)

    Are you sure that there are records for which [convert]-[left] is larger than 72?

  5. #5
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: conditional formating (2000)

    yes, regardless of the number it turns the font of the answer to red. The answer from this box is dependent on [convert] text box calculation and a [Left] text box that computes a date diff number if this helps.

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

    Re: conditional formating (2000)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  7. #7
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: conditional formating (2000)

    I have figured it out. Since it is a calculation text box I have to put the expression in the formating instead of less than or equal to.

    Thanks

Posting Permissions

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