Thread: Colorindex
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Colorindex
Activecell.FormatConditions(1).Interior.ColorIndex
to check the condition 1 colorindex

Activecell.FormatConditions(2).Interior.ColorIndex
to check the condition 2 colorindex

Activecell.FormatConditions.Count
to get the number of conditions applied

If this post helps click Yes
---------------
Jacob Skaria


"Al_82" wrote:

Is there any way to determine the colorindex of a conditionally formatted cell?
--
Al_82
Reply With QuoteReply With Quote