Thread: Change colour of cell depending on content
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Change colour of cell depending on content
Hi Blain,

Replace:

Case "NORA": .Interior.ColorIndex = 16

with
Case "NORA": .Interior.ColorIndex = 16
Case Else: .Interior.ColorIndex = xlNone

---
Regards,
Norman


Reply With QuoteReply With Quote