Dynamic Highlight records based on criteria

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hi,

I want to highlight a row in a table if the "Ready-to-ship Date" is Due (from Today), but I also want it to stop being highlighted if a "Shipping Date" has been selected.


i.e. The Ready-to-ship date is yesterday, so it shows a highlighted row, but say next week I finally manage to arrange the shipping date and from the moment I enter a Shipping Date the row on the table is NOT highlighted anymore. Suggestions? 


If([Ready-to-ship Date]<Today() and 

[Shipping Date] I*S*   E*M*P*T*Y*,

"#FF9999","#F8F8F8")

Photo of Michael

Michael

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
If( [Ready-to-ship Date] < Today() and IsNull( [Shipping Date] ), "#FF9999" , "#F8F8F8")