Thread: Color of cell.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mangesh Yadav[_4_] Mangesh Yadav[_4_] is offline
external usenet poster
  
Posts: 101
Default Color of cell.
If Range("A1").Interior.ColorIndex = 1 then


Mangesh



"Tom" wrote in message
...
Hello,

how can I identify which "fill color" is used on cell.

For example:

whatColor = range("A1")
If whatColor = 1 then ....


thanks Tom




Reply With QuoteReply With Quote