But for the formula, add another ,"No" between the 2 closing parenthesis, so if the planned completion date isn't less then today, "No") IF(Planned Completion Date<$$TODAY,IFIN(Status,'NEW','INP','ONH',"Yes","No (Closed)"),"No (Current)") On Tue, Aug 23, 2016 at 12:41 PM Melinda Layten < reportingforum@communitylists.workfront.com> wrote: > The conditional formatting executes sequentially. > So if your first condition is if closed then white, then your second > condition can be if due < today then red, third if due < today+2 then > yellow, else green > > On Tue, Aug 23, 2016, 12:12 PM Melissa Averkamp < > reportingforum@communitylists.workfront.com> wrote: > >> We are working on a go-live task report, and we'd like to use the >> conditional formatting available in the report builder to turn an entire >> task row a different color if the planned completion date of the task is >> less than today and the status isn't closed. However, this isn't possible >> based on current functionality. So, we have created a custom calculated >> field to perform the calculation as follows: >> >> IF(Planned Completion >> Date<$$TODAY,IFIN(Status,'NEW','INP','ONH',"Yes","No")) >> >> We can get it to work for those tasks that are truly overdue and it >> displays 'Yes', but those that aren't display a blank. I'm sure that we're >> missing a simple thing, but cannot figure it out. >> >> Can anyone else spot it? >> >> Thanks for your help! >> >> -----End Original Message----- >