Need help with row colorization for two conditions at once.

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
Trying to have row turn red if one date field is past due and another date field is blank at the same time.
Photo of Evo Administrator

Evo Administrator

  • 130 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

if(

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

)


(Edited)
Photo of Evo Administrator

Evo Administrator

  • 130 Points 100 badge 2x thumb
Perfect, thanks!