View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim at Eagle Jim at Eagle is offline
external usenet poster
 
Posts: 83
Default Loop criteria based on cell value and color

If rng.Value = Val1 & Interior.ColorIndex = 36 Then

how do I get there
--
Jim at Eagle