+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Conditional formatting in Excel 2007

  1. 05-25-2012, 09:02 AM #1
    jpgerard
    jpgerard is offline
    Registered User
    Join Date
    03-30-2011
    Location
    Parsippny, NJ
    MS-Off Ver
    Excel 2007
    Posts
    2

    Conditional formatting in Excel 2007

    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.
    Reply With QuoteRegister To Reply
  2. 05-25-2012, 09:08 AM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Conditional formatting in Excel 2007

    Hello & Welcome to the Forum,

    It could be something within that particular workbook.

    Does this happen with other workbooks?
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  3. 05-25-2012, 09:17 AM #3
    jpgerard
    jpgerard is offline
    Registered User
    Join Date
    03-30-2011
    Location
    Parsippny, NJ
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Conditional formatting in Excel 2007

    It does happen with other workbooks. I even tried a blank workbook but the problem still happened.
    Reply With QuoteRegister To Reply
  4. 05-25-2012, 09:21 AM #4
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Conditional formatting in Excel 2007

    Not so sure, but maybe somebody else has an idea. One or two cells does not make sense.
    Reply With QuoteRegister To Reply
  5. 05-25-2012, 10:02 AM #5
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,621

    Re: Conditional formatting in Excel 2007

    I take it that you have not had a problem in the past? It has just started happening recently? What has changed? Have you added anything? Applications, add-ins, whatever?

    It's probably unfair to generalise and point the finger, but the Skype Click to Call Add-in has been having odd effects, particularly visible with Copy and Paste in Excel. I experienced this personally and I wasn't very happy about it. This may be another symptom.

    If you have recently upgraded Skype and/or installed Skype Click to Call, I would suggest you uninstall the Add-in.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  6. 05-25-2012, 10:03 AM #6
    darknation144
    darknation144 is offline
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Conditional formatting in Excel 2007

    What format is it saved in? try resaving it in .xlsx and see if it still happens.
    If someone helped give them rep using the star button.

    If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
    Reply With QuoteRegister To Reply
  7. 05-25-2012, 10:43 AM #7
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Conditional formatting in Excel 2007

    To quote IT Crowd, "Have you tried turnin' it off 'n' on again?"
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  8. 05-25-2012, 03:21 PM #8
    Russell Dawson
    Russell Dawson is offline
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Conditional formatting in Excel 2007

    Do you have colour fill or borders which have been set to fill full columns or rows rather than the active part of the worksheet?
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1