Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Moving thread to Excel Forum

    Hello,

    I desperately need help in the easiest way to highlight dates that are out of sync.
    I work with Forecast dates and I need a formula or conditional format that highlights dates that our larger than the previous forecast date.

    Example:
    If column I (F090) has a date that is larger than columns J (F091), then highlight. I need the conditional formatting to start at Column I thru Column N.

    Dates should be in sequence: 2/15/14, 2/16/14, 2/18/14, etc.
    Highlight if a date is not in sequence: 2/15/14, 3/28/14, 2/18/14, etc.

    I really appreciate any assistance I can get.
    Thank you.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Are you talking about MS Access? Do you use a continuous or datasheet form?

    If the answer to both questions is yes:
    - Open the form in design view.
    - Right-click on a control that must be formated and select Conditional Formatting.
    - For the condition, select Expression is then type the expression (example: if the control is F090 type: [F090] > [F091]).
    - Select the format to be appplied when the expression is True.
    - Repeat for each control.
    Have a nice day!

  3. #3
    Join Date
    Sep 2008
    Posts
    150
    OMG! I just realized that I posted my question in the wrong forum. I meant to post it in the Excel forum.

    Thank you Sinndho for your prompt response. I need help with Conditional Fomatting in Excel. I wil repost in Excel. Again, thank you.

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!

    Notice that the principle would probably be the same with Excel (Access "inherited" this conditional formatting feature from Excel, many years ago).
    Have a nice day!

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by mlrnet View Post

    ...I just realized that I posted my question in the wrong forum. I meant to post it in the Excel forum...
    No problem, mlrnet! I've moved it over to the Excel Forum.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    Join Date
    Sep 2008
    Posts
    150
    Hi Sinndho,

    Is there a way to do a conditional format from an access (2010) query? Can I color code the dates that are not in sync straight from he query?

  7. #7
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Not in a query. Generally speaking users should not be allowed to directly open tables or queries. The normal way of doing things consists in creating a form and associate it to a query (or to a table) through its (Form) RecordSource property. There are Wizards in Access that can create such a form for you. You can then use the contitional format feature on the controls (usually Textbox controls) of the form.
    Have a nice day!

  8. #8
    Join Date
    Sep 2008
    Posts
    150
    Got it!

    Thank you for your response Sinndho. I really appreciate it. :-)

  9. #9
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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