Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    155
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Conditional Formatting (Excel 2000 SP3)

    I have an Excel workbook which tracks sales invoices, and I would like to make it more useful by incorporating some credit control features.

    Specifically I would like to highlight certain cells with a particular background (fill) colour if certain criteria are met.

    The workbook is a standard table with columns headed Invoice No.; Date; Client; Job; Amount; Date sent; Date Paid; Shortfall (if any) etc etc.

    In

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (Excel 2000 SP3)

    Sure, use this formula in the conditional format (after choosing "Formula Is" in the first dropdown:

    =AND(TODAY()-B3>30,TODAY()-B3<61,OR(B4="",B5>0))

    B3 is the Date sent
    B4 contains date paid
    B5 contains shortfall.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Posts
    155
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (Excel 2000 SP3)

    Jan

    Sorry - I've only just had chance to try this one out.

    Fantastic!! I only discovered conditional formatting after seeing the phrase in the title of someone else's post, but it is certainly a very powerful tool.

    Thanks very much for your assistance with this!

    Neil

Posting Permissions

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