Highlight a field in a report
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?
Forum Discussion
1 Reply
- 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
