Color code condition

[Anonymous]

Document Received	Priority	Status
06 May 2016	Medium	Closed
07 April 2016	High	Open
07 April 2016	High	Closed
06 May 2016	Medium	Open

I want

1)if the priority is high and document received (current date- date received) is more than 4 months, status is open then it is coming on red

2)if the priority is medium and document received (current date- date received) is more than 10 months, status is open then it is coming on red

3) if the priority is high and status is closed then it is coming on green

4)if the priority is medium and status is closed then it is coming on green

[johnw]

Maybe this?

if(Status='Closed',green()
,if(Priority='High' and today() > addmonths([Document Received],4),red()
,if(Priority='Medium' and today() > addmonths([Document Recieved],10),red())))

[Anonymous]

if(Status = 'Closed',

  green(),

  if(Priority = 'High' and [Document Received] < AddMonths(Today(),-4) and Status = 'Open',

  red(),

  if(Priority = 'Medium' and [Document Received] < AddMonths(Today(),-10) and Status = 'Open',

  red())))