Numbers If Statement Help

Discussion in 'Mac Basics and Help' started by Devan, Jan 9, 2009.

  1. macrumors newbie

    Joined:
    Jan 8, 2009
    #1
    Ive created a way i can manage some projects on numbers for a few paid clients.

    Just wondering how would i do this?

    If Project Status = Active
    Echo Project Name + Project Description + Due Date + Client Name

    any ideas?

    Some clients have multiple projects in their spreadsheet.

    any ideas?
     
  2. macrumors 6502

    reclusivemonkey

    Joined:
    Jun 2, 2008
    Location:
    Sowerby Bridge, West Yorkshire, UK
    #2
    For a single line, you can use something like;

    Code:
    =IF(A2="Active",CONCATENATE(B2,"-",C2,"-",D2)
    
     
  3. macrumors newbie

    Joined:
    Nov 30, 2012
    #3
    If Statement Help

    Hi People,

    I am trying to find out if it is possible to change the color of a cell using the If Statement.

    I have a function set-up to monitor my medication stock so that when a particular medication's stock falls below a certain number the cell text changes to "Re-Order"; however I would really like to have the cell color change too.

    Any ideas ?

    Regards,

    Mike
     

Share This Page