Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I make an expiry date show-up in a different colour?

Discussion in 'Information Technology' started by renate, Oct 27, 2005.

  1. renate

    renate
    Expand Collapse
    Guest

    Hi there

    I need to accentuate an expiry date in a different colour, how do I do that?
    So I would like to put in a date and for excell to calculate the date a year
    from that date and show me that in for example red. I hope yiu undertsand my
    question.

    Thanks, Renate
     
  2. Loading...


  3. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    If this question is for Excel, please try one of the Excel newsgroups. This
    one is for the Access Database program.
    Before you do that, if you want to change colours based on a value, check
    the help file for Conditional Formatting.

    --
    Wayne Morgan
    MS Access MVP


    "renate" <renate@discussions.microsoft.com> wrote in message
    news:FDAF6B3B-24E4-4D3B-97F4-F28185FA3DB7@microsoft.com...
    > Hi there
    >
    > I need to accentuate an expiry date in a different colour, how do I do
    > that?
    > So I would like to put in a date and for excell to calculate the date a
    > year
    > from that date and show me that in for example red. I hope yiu undertsand
    > my
    > question.
    >
    > Thanks, Renate
     

Share This Page