Hi all,
I need to export to excel a table which has traffic lights as one of the columns. I haven't found a possibility to do so with standard QV functionality. My only option now is to write a macro that would apply a custom format in excel so that the numbers look like traffic lights.
But I have problems writing a macro.
Attached is a QV file with the table that needs to be exported and a macro that exports it to excel. The format that needs to be applied is ##,##0.0,,;[Red](#,##0.0,,)
This should make it look like this:
I would really appreciate if anyone could help me with that.
Thank you!