Skip to main content
Question

Highlight a field in a report

  • May 10, 2017
  • 0 replies
  • 16 views
I need to Highlight {Construction Start Date} field in a report in RED if it is before [Anticipated Delivery Date] or Highlight the field in Yellow if the dates are the same.  how do I do this? Help please?
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • May 10, 2017
      In the "Customize This Report" settings you can add colorization to the row if the criteria is met.

      Your formula would look something like this:

      If([Construction Start Date]<[Anticipated Delivery Date], "red", 
      If([Construction Start Date]=[Anticipated Delivery Date], "yellow", ""))

      You can replace "red" with some color hex if you want to be more precise with the colors
      "#565656", etc
      Terms & ConditionsAccessibility statement