dek
09-15-2010, 06:45 PM
Hi,
I have setup a capacity schedule ("rpt.Rig Schedule) which automatically colors the assets activity (using conditional formatting).
I am also trying to overlay the client's name for each asset without impacting the conditional formatting (which is driven from the cells formula value). See row 10 for illustration.
Assistance appreciated. I assume this requires a VBA solution.
I have setup a capacity schedule ("rpt.Rig Schedule) which automatically colors the assets activity (using conditional formatting).
I am also trying to overlay the client's name for each asset without impacting the conditional formatting (which is driven from the cells formula value). See row 10 for illustration.
Assistance appreciated. I assume this requires a VBA solution.