Discussions

Expand all | Collapse all

Highlight a field in a report

  • 1.  Highlight a field in a report

    Posted 05-09-2017 20:11
    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?


  • 2.  RE: Highlight a field in a report

    Posted 05-09-2017 20:28
    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