Thread: See conditional formatting Color value in vba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gunnar Sandström Gunnar Sandström is offline
external usenet poster
  
Posts: 1
Default See conditional formatting Color value in vba
Hi!
what code do i use in vba to determin the background color of a cell caused
by conditional formatting?

When i use ex :
bcolor = ActiveCell.Interior.ColorIndex
bpcolor = ActiveCell.Interior.PatternColor
i do not se the color caused by conditional formatting.

\\\ Gunnar


Reply With QuoteReply With Quote