I have a client that is requesting my custom as-staked report flags certain values with different colors. It appears the only thing I can do is set the horizontal and vertical tolerances in TBC so that those values get flagged red in the report. I don't see a way to have another color flag another range of values. Just wondering if there is a way to do that? I have tried to do it in the word document but there doesn't seem to be an easy way to do it. I was able to create a macro but then I couldn't save the custom layout as a docx meaning I couldn't actually use it to generate the report. If anyone has any suggestions that would be appreciated.
Thanks
Export report as CSV or xls.
Use Excel and conditional formatting.