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.
|