Thread: How to check if cell has conditional formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John[_141_] John[_141_] is offline
external usenet poster
  
Posts: 14
Default How to check if cell has conditional formatting
On Apr 1, 9:58*am, John wrote:
Is there a way tocheckif the active cell has any conditionalformatting?

Sorry....looks like this might work:
If range("A1").FormatConditions.Count 0
Reply With QuoteReply With Quote