Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional coloring of a task (name field)

Status
Not open for further replies.

Hesaf

IS-IT--Management
Aug 12, 2008
15
0
0
EU
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top