AnsweredAssumed Answered

Conditional Formatting based on another field date

Question asked by FM_DM on Feb 12, 2019
Latest reply on Feb 13, 2019 by FM_DM

Hi

Hopefully a quick one. I have a quotations database which has different status for each quote. What I would like to do is have the status highlight red when three months have passed from the last modification date and the field contains the text either "preparing quotation", "Quotation Accepted  - Job Raised" or " Quotation Submitted".

 

I can figure how to have it highlight based on the text within but I think I might be missing the obvious with the date thing.

Outcomes