test for formatting in VBA
Posted by Wiggy on January 20, 2002 3:57 AM
I have set up the Gant Chart as a staff rots sheet
Great Conditional Formatting etc looks good....my next task!
Iwant to automatically insert .5 hours in each columb that is formatted to add up worked hours each half hour.
This helps us link peak times with staff numbers.
I want to test for say yellow fill and auto insert .5
This is my dificulty testing for the fill color
Anyone Help ??
Barry or Wiggy