Thread: Is there is a way to tell conditional formatting is on?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Is there is a way to tell conditional formatting is on?
Hi

If range("A1").FormatConditions.Count 0 then
msgbox "conditional formating applied for cell A1"
end if


--
Regards
Frank Kabel
Frankfurt, Germany

luvgreen wrote:
I want to if I can tell conditianl formatting is turned on in the
VBA?
Thanks.

Reply With QuoteReply With Quote