Numbers If Statement Help

[Devan]

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?

 

[reclusivemonkey]

For a single line, you can use something like;

=IF(A2="Active",CONCATENATE(B2,"-",C2,"-",D2)

 

[mikeyb01603]

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