View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 59
Default finding conditional formatting cells

I am trying to find cells that have conditional formatting in them.
I was thinking just to turn the cell a specific color. or something.
But I am having a hard time finding them.

For instance. I put a conditional formatting statment on a cell.
then I select a bunch of cells
then I perform the following:

Dim x As Excel.Range
Set x = Excel.Selection
MsgBox x.FormatConditions.Count

and I get -1

is there a way I can ID each cell in a sheet. that has conditional
formatting?

thanks