Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting Erratic (2003 SP 2)

    I have a worksheet with conditional formatting. The cells are formatted so that IF the value in a cell equals the minimum in a range, the font is green.. IF the value equals the maximum in a range, the font is red. This works most of the time, but not all the time. I can look at the worksheet and see that six entries equal the minimum in the range. Five are formatted green, one is not. I've double-checked the range, the reference, the formual... all seem the same in all rows. I can tweak the mis-behaving cells to make them turn color... if I force the value to be a new minimum or maximum for the range, the conditional formatting works properly. If I turn the value back to equal old minimum/maximum, the conditional formatting does not work right.

    Any thoughts on what's going on?

    thanks

    Don

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

    Re: Conditional Formatting Erratic (2003 SP 2)

    Could it be caused by small rounding errors?

    If you post a small sample workbook demonstrating the problem, Loungers could investigate the problem directly.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting Erratic (2003 SP 2)

    I'd thought of that... but I'm only using whole numbers. (Time, actually)

    II don't have the workbook right at this moment, but 'll try to post Thursday.

    thanks,

    Don

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting Erratic (2003 SP 2)

    Well, Excel stores time values at fractions of a day, so rounding error is a deffinite possibility.
    Legare Coleman

Posting Permissions

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