Discussions

Expand all | Collapse all

Need help with row colorization for two conditions at once.

  • 1.  Need help with row colorization for two conditions at once.

    Posted 04-02-2018 15:45
    Trying to have row turn red if one date field is past due and another date field is blank at the same time.


  • 2.  RE: Need help with row colorization for two conditions at once.

    Posted 04-02-2018 15:47

    if(

    [One Date field]>=[Past Due Date] and isnull([another date field]), "#FF0000",""

    )




  • 3.  RE: Need help with row colorization for two conditions at once.

    Posted 04-02-2018 15:50
    Perfect, thanks!