Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 9, 2009, 12:07 PM   #1
Devan
macrumors newbie
 
Join Date: Jan 2009
Numbers If Statement Help

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?
Devan is offline   0 Reply With Quote
Old Jan 9, 2009, 02:11 PM   #2
reclusivemonkey
macrumors 6502
 
Join Date: Jun 2008
Location: Sowerby Bridge, West Yorkshire, UK
For a single line, you can use something like;

Code:
=IF(A2="Active",CONCATENATE(B2,"-",C2,"-",D2)
reclusivemonkey is offline   0 Reply With Quote
Old Nov 30, 2012, 03:26 PM   #3
mikeyb01603
macrumors newbie
 
Join Date: Nov 2012
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
mikeyb01603 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
IF Statement Help jbgolfnut Mac Basics and Help 5 Aug 25, 2011 12:23 PM
IF Statement in Numbers regarding four different outcomes Sam1487 Mac Basics and Help 1 Nov 23, 2010 05:24 PM
Excel Nested If statement help Gandalf! Mac Basics and Help 0 Sep 10, 2010 08:45 AM
numbers 09 if statement condition webgoat Mac Applications and Mac App Store 0 Apr 3, 2009 02:44 PM
Help with basic if statement Buschmaster Mac Programming 2 Mar 11, 2008 03:49 PM


All times are GMT -5. The time now is 02:05 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC