1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Open Source Spreadsheet help

Discussion in 'Tech Support' started by Ryu_ookami, 26 Feb 2019.

  1. Ryu_ookami

    Ryu_ookami I write therefore I suffer.

    Joined:
    11 Mar 2004
    Posts:
    3,311
    Likes Received:
    126
    I'm trying to create a spreadsheet in which I can place a list of name and set them to either 1 month member, 3 month member or lifetime member what I want is the cell that 1 month members names are in to turn red after that specific member has been on the list for 28 days and for the 3 months members names to do the same but after 84 days, but I've go no idea where to start.

    (I'm currently using open office)
     
  2. MadGinga

    MadGinga oooh whats this do?

    Joined:
    19 Mar 2009
    Posts:
    1,875
    Likes Received:
    99
    I think what you're looking for could easily be done with conditional formatting, linked to a date (of joining) field?
     
  3. goldstar0011

    goldstar0011 Well-Known Member

    Joined:
    2 Sep 2007
    Posts:
    3,047
    Likes Received:
    140
  4. ModSquid

    ModSquid Member

    Joined:
    16 Apr 2011
    Posts:
    458
    Likes Received:
    9
    Did you manage to get this sorted?
     
  5. Ryu_ookami

    Ryu_ookami I write therefore I suffer.

    Joined:
    11 Mar 2004
    Posts:
    3,311
    Likes Received:
    126
    yes thank you
     

Share This Page