Route Report Excel Export Conditional Formatting
Not sure about colors. Never tried it. But you can definitely output different text depending on conditions.
Not sure about colors. Never tried it. But you can definitely output different text depending on conditions.
Is it possible to add some conditional formatting to the excel reports? I have edited the report to export the SpeedLimit beside the Speed column.
I want to add in some conditional formatting if the speed is over the speed limit by 10mph it will be yellow, 20 over would be amber and 30 over would be red.