By using this website, you agree to our Terms of Use (click here)
So far This is how I got the closest to what I wanted: =IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.CuryDocBal]>0, 'red0','default'), 'g...
@ryanxbyte I see, but I meant was, that it applies color even to those are closed: =IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.OpenDoc]=0,...
@ryanxbyte This is what the outcome 🙁
If I put =IIf( [APInvoice.DueDate]<Today(), 'yellow60', 'default') - it turns due date that are less than today to yellow, including those are clos...
@ryanxbyte Thank you for your reply! I just tried your way - didn't work either, not sure why...
Does conditional formatting in GI allow to use nested formulas? I tried to apply color to only open bills that are past due, and it didn't work: ...
