Results 1 to 4 of 4

Thread: Excel (2002)

  1. #1
    New Lounger
    Join Date
    Nov 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel (2002)

    I'm a novice with excel & all help is appreciated. Is there a way to change the color of a cell based
    on an expiration date inside it? Sort of an alert to a deadline.

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel (2002)

    If you highlight B310
    Format - conditional formatting
    formula is
    =$D3<now()
    <format> [choose pattern tab color to highlight
    <ok><ok>

    You will "highlight" all three columns if col d is < today's date.

    Steve

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

    Re: Excel (2002)

    You haven't specified how and when you want to color the cells, but the tool to use is Format | Conditional Formatting...

    Select the cells whose color you want to change.
    Select Format | Conditional Formatting...
    Select Formula Is in the first dropdown list.
    Enter a formula with a condition for the first cell; for instance if you set conditional formatting for D29 on Sheet1:

    =D2<TODAY()

    if you want to color cells whose expiry date has passed, or

    =D2<TODAY()+30

    if you want to color cells whose expiry date is less than 30 days away (or has passed).
    Click the Format... button and set the font, border and shading properties you want to use.
    Click OK (twice).

    See attached modified workbook.

  4. #4
    New Lounger
    Join Date
    Nov 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel (2002)

    Thanks for the help guys. Got it to work now.

Posting Permissions

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