View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
luvgreen[_3_] luvgreen[_3_] is offline
external usenet poster
 
Posts: 11
Default Is there is a way to tell conditional formatting is on?

Thank you for all replies. In my case, many cells have different conditional formattings. Is there a way to tell that any of the conditional formattting is on? I am sorry to keep repeating this question.

I tired to use the range.interior.colorindex to see if the color is changed, but it seems the interior color did not change even when the conditional formatting is on. How can I tell the color is changed in the cell from the code which going through each cell with the conditions applied to the cell? Thanks a lot.