Hi,
we use XPI: and XPO: for incoming and outgoing interfaces.
We want to color only the NAME column RED when 'XPI:'-string is taken in the NAME field (starts with XPI.
We want to color only the NAME column GREEN when 'XPO:'-string is taken in the NAME field (starts with XPO.
I read a lot about macros but I wasn't able to make it workable. Do we need a macro (Excel has conditional coloring)? If yes what is the correct and complete code to support this (I guess the module schould be taken in de project global or in the VBAProject part?).
The way of working should be that as soon as a new task is created or content (NAME field) is changed that the correct color is validated at the same time without pressing a macro button.
Thanks.
we use XPI: and XPO: for incoming and outgoing interfaces.
We want to color only the NAME column RED when 'XPI:'-string is taken in the NAME field (starts with XPI.
We want to color only the NAME column GREEN when 'XPO:'-string is taken in the NAME field (starts with XPO.
I read a lot about macros but I wasn't able to make it workable. Do we need a macro (Excel has conditional coloring)? If yes what is the correct and complete code to support this (I guess the module schould be taken in de project global or in the VBAProject part?).
The way of working should be that as soon as a new task is created or content (NAME field) is changed that the correct color is validated at the same time without pressing a macro button.
Thanks.