Hi,

I am having a problem when trying to add conditional formatting to an Excel 2007 spreadsheet. I am using the format painter to to copy the formatting of a few cells at a time and when I try to paint the formatting on to other cells, it produces an error message saying "Excel cannot complete this task with available resources. Choose less data or close other applications."

I get this message even when only painting 1 or 2 cells at a time and when all other applications on my laptop are closed. My laptop has 8 GB of RAM.

I would appreciate any help with this.