Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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...

    Similar Threads Forum Date
    Sikh News Tarlochan quits as NCM chief after term expiry (India Daily) Breaking News Feb 12, 2006
    Sikh News Tarlochan quits as NCM chief after term expiry (India Daily) Breaking News Feb 11, 2006
    Self Update On The Gurdwara Blogs Apr 3, 2017
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Sikh News Sikh Candidate In Hamilton Disgusted By Racist Vandalism - Newstalk ZB Breaking News Aug 22, 2016

  3. OP
    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
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page