View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg
 
Posts: n/a
Default Counting Cells with Conditional Formatting

One way of turning conditional formatting into regular formatting
is to copy your data array to Word, and then bring it back to Excel.

Another, harder way is to make a copy to another location in your
workbook,
write your conditional formulas as number generating formulas and
Find (number), Replace (format) and
Copy, Paste Special, Format to the original array.