View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Determine in VBA if a cell has conditional formatting applied

Try something like this:

ActiveCell.FormatConditions.Count 0

--
Jim
"Chuck M" wrote in message
...
| Hi,
|
| Is there a way to determine through VBA if a cell has conditional
formatting
| applied to it?
|
| --
| TIA
| Chuck M.