Thread: Detect if conditional format is true
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
LeninVMS[_2_] LeninVMS[_2_] is offline
external usenet poster
  
Posts: 1
Default Detect if conditional format is true
You can use the FormatConditions property of the Range object t
distinguish between cells that have conditional formats and those tha
do not.

E.g:

Count all red cells using cells(x,y).interior.colorindex

If (Cells(i,j).FormatConditions.Count<0) Then
'Identify color of cell and decrease count from total number o
red cells

End if

- Leni

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote