View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
obsessive obsessive is offline
external usenet poster
 
Posts: 12
Default Conditional BackColor Loop

Thanks again for the code.
Am trying to work out a small bug however.
The current code highlights ALL the textboxes, not just the ones
outside the variance.
I am trying to only highlight the textboxes with values that are
outside the variance.
If they are "within spec" the backcolor should not be changed.
Will post again if/when I figure it out.
Regards