View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mistus mistus is offline
external usenet poster
 
Posts: 1
Default VBA colorscale and color #

hi,
i have a colorscale (conditional formating ) in range A1:A20 and I'm
trying to get color number for each cell. In normal case

a = Range("a1").Interior.Color
b= Range("a2").Interior.Color etc.

works fine.
But when colors of cells are from conditional formating i dont know
how to get color number.
how to do that?
Mistus