+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - multiple formats

  1. #1
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    151

    Conditional Formatting - multiple formats

    I have recorded the following macro, but then when I re-run it I get an eerror on ".italic = True". Looks like the error always comes up on the second format under the with statement. Any ideas? The error is "Run-time error '-2147417848 (80010108)': Method 'Color' of object 'Font' failed

    Please Login or Register  to view this content.
    pls click the star if you liked my answer!

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Conditional Formatting - multiple formats

    Hi,
    This works for me (on Excel 2013)

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    151

    Re: Conditional Formatting - multiple formats

    I get the same error I was getting before on ".color". Any reason this would not work in 2010? It is weird bc I just re-run the macro that I recorded and get an error without changing anything...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting - Date formats
    By redforlife in forum Excel General
    Replies: 1
    Last Post: 01-14-2015, 08:42 PM
  2. Remove conditional formatting, keep formats.
    By elmaco12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 10:58 AM
  3. [SOLVED] Conditional Formatting Formats All
    By uckycool in forum Excel General
    Replies: 8
    Last Post: 10-03-2012, 11:06 AM
  4. Replies: 0
    Last Post: 07-02-2012, 06:09 PM
  5. Replies: 1
    Last Post: 09-22-2011, 05:42 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1