Visualize Data Through Target Metrics and Conditional Formatting

REIF creates data visualization through color changing cells (i.e. conditional formatting) based on the value outputs relative to target metrics. This generates visual reports to analyze your property quickly and accurately.


To adjust your formatting, go to the "Settings" tab under "Target Metrics: Conditional Formatting" to set "Neutral" and "1 Point" values for Target Metrics. Input target metric hurdles that will create color changing cells based on the output values to identify if those metrics are great, good, average, poor, or awful.

  • Neutral = value that would generate an average outcome (e.g. target bogey)

  • 1 Point = amount from "Neutral" in order to generate a positive or negative outcome


Return Example: Neutral = 20% | 1 Point = 5%

  • Great > 30% = Green Highlighted

  • Good > 25% = Green Bold

  • Average = 15% to 20% = No Change to Formatting (Black)

  • Poor < 15% = Red Bold

  • Awful < 10% = Red Highlighted


As you adjust these Target Metric settings and/or change your data inputs, so will the colors of the cell values.


Recent Posts

See All