Quarter and expression help

[#1]

Hello,

I am trying to accomplish the following in a chart:

1. Status = In Progress and End Quarter has not passed , GREEN

2. Status = Not Started and Start Quarter has passed , RED

3. Status = In Progress and End Quarter has passed , RED

My start and end quarters are 1,2,3,4 in the database. How do I compare to current quarter?

I have this working so far

=if(Status='Not Started' and START_QUARTER>1,RGB(255,153,153), IF(Status = 'In-Progress',RGB(0,255,0)))

Can anyone suggest how to get three conditions working in one column?

Thanks.

[alexandros17]

if(cond1, RGB(...),

if(cond2, RGB(...),

if(cond3, RGB(...)

, RGB())

)