AnsweredAssumed Answered

Conditional Formatting

Question asked by mrosenhek on Jun 15, 2016
Latest reply on Jan 17, 2018 by user26871

I have a date field (FIELD AAA) that needs to have conditional formatting applied to it. I can't see the forest for the trees anymore, and if anybody can help me I will be most  appreciative.

 

Three conditions need to be applied to FIELD AAA

 

If today's date is up to 30 days prior to FIELD AAA or past FIELD AAA , then the colour red.

 

If today's date is between 31 to 60 days prior to FIELD AAA , then the colour amber.

 

If today's date is between 61 to 90 days prior to FIELD AAA , then the colour amber.

 

Thank you.

Outcomes